newb question: ... LIKE "%somestring%" fails

------=_NextPart_000_0009_01C4C64B.A40BF370
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hello everyone,



I'm trying to get a query going which contains a percentage mark (in
conjunction with the sql LIKE operator). Perl doesn't seem to like this in a
string (containing my query) however. Does anyone know how to circumvent or
solve this?



Thanks in advance,



Edgar Meij


------=_NextPart_000_0009_01C4C64B.A40BF370--

RE: newb question: ... LIKE "%somestring%" fails

Escape the % signs like "\%something\%"

Regards,
Pete
----
Peter P. Benac, CCNA
Celtic Spirit Networking
Providing Network and Systems Project Management and Installation and =
Web
Hosting.
Phone: 919-618-2557
Web: http://www.emacolet.com
Need quick reliable Systems or Network Management advice visit
http://www.nmsusers.org

To have principles...
First have courage.. With principles comes integrity!!!




-----Original Message-----
From: Edgar Meij [mailto:Edgar.Meij@student.uva.nl]=20
Sent: Tuesday, November 09, 2004 5:03 AM
To: perl@lists.mysql.com
Subject: newb question: ... LIKE "%somestring%" fails


Hello everyone,

=20

I'm trying to get a query going which contains a percentage mark (in
conjunction with the sql LIKE operator). Perl doesn't seem to like this =
in a
string (containing my query) however. Does anyone know how to circumvent =
or
solve this?

=20

Thanks in advance,

=20

Edgar Meij



--
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