Hi,

I have a database column of char(250); I can insert enmass a string 
into said column using:

update tablename set columnname = concat(columnname, 'string');

but how do I undo that?

Is there a function that is exactly the reverse of concat such
that:

update tablename set columnname = unconcat(columnname, 'string');
will actually delete 'string' pattern from columnname?

thanks
Jaime




---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to