the MySQL supplied ones and
I don't know if that's just because they're old (if it isn't broken,
don't fix it) or there's some more significant reason behind it.
--
Mark Rogers // More Solutions Ltd (Peterborough Office) // 0845 45 89 555
Registered in England (0456 0902) at 13 Clarke Rd
by 'text1', would
UPDATE tbl_idea SET col1=CONCAT('text',ideaID), cols=NOW();
.. be close? Don't test it unless you're sure, it'll change all the
records in the table!
--
Mark Rogers // More Solutions Ltd (Peterborough Office) // 0845 45 89 555
Registered in England (0456 0902) at 13 Clarke Rd