Depending on what you mean 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) //
rtup sripts are very from 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) //
