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 =
UPDATE tablename SET columnname = substring(columnname, 1, if
(locate('string', columnname) 0, locate('string', columnname) - 1,
length(columnname)));
Hi,
I have a database column of char(250); I can insert enmass a string
into said column using:
update tablename set columnname =