join strings

am 25.06.2004 12:13:25 von Jan Eden

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

security perl script

am 25.06.2004 14:07:39 von lshen

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

Brian
----- Original Message -----
From: "Jan Eden"
To: "Perl Lists"
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@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@m .gmane.org

security perl script

am 25.06.2004 14:07:39 von lshen