join strings

Hi,

sorry, this is not related directly to Perl.

How can I concatenate an existing string value with a prefix?

I tried:

UPDATE genres SET genre_name =3D CONCAT ('Prefix 2:', genre_name) WHERE gen=
re_name NOT REGEXP '^Prefix 1:';

But got an error.

Any hints?

Thank you,

Jan
--=20
Either this man is dead or my watch has stopped. - Groucho Marx

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org