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
--
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 [at] m.gmane.org

Dose anyone know where can i find a simaple dencryption encryption perl
script? thanks

Brian
----- Original Message -----
From: "Jan Eden" <lists [at] janeden.org>
To: "Perl Lists" <perl [at] lists.mysql.com>
Sent: Friday, June 25, 2004 6:13 AM
Subject: 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 = CONCAT ('Prefix 2:', genre_name) WHERE
genre_name NOT REGEXP '^Prefix 1:';

But got an error.

Any hints?

Thank you,

Jan
--
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=lshen [at] pop900.gsfc.nasa.gov



--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules [at] m .gmane.org

Dose anyone know where can i find a simaple dencryption encryption perl
script? thanks

Brian
----- Original Message -----
From: "Jan Eden" <lists [at] janeden.org>
To: "Perl Lists" <perl [at] lists.mysql.com>
Sent: Friday, June 25, 2004 6:13 AM
Subject: 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 = CONCAT ('Prefix 2:', genre_name) WHERE
genre_name NOT REGEXP '^Prefix 1:';

But got an error.

Any hints?

Thank you,

Jan
--
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=lshen [at] pop900.gsfc.nasa.gov



--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules [at] m .gmane.org