Join the content from two columns
SELECT CONCAT(`firstname`, `surname`)FROM `table`
Format the date becuase I can just about understand the formating on a digital watch
SELECT DATE_FORMAT('2008-11-14 21:45:00', '%W %M %Y');
When am I likely to be finished with my to do list
select date_add(max(datedone), interval ( (total - max(done)) / ( max(done) / (datediff(max(datedone), min(datedone))) ) ) day ) as enddate from objectives
An easy way of carrying out a search and replace
UPDATE stuff SET mycol=(replace (mycol, 'foo','bar'));
