2 messages in com.mysql.lists.perlRE: newb question: ... LIKE "%somestr...
FromSent OnAttachments
Edgar Meij09 Nov 2004 02:02 
Peter P. Benac09 Nov 2004 02:26 
Subject:RE: newb question: ... LIKE "%somestring%" fails
From:Peter P. Benac (ppbe@emacolet.com)
Date:11/09/2004 02:26:16 AM
List:com.mysql.lists.perl

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:Edga@student.uva.nl] Sent: Tuesday, November 09, 2004 5:03 AM To: pe@lists.mysql.com Subject: newb question: ... LIKE "%somestring%" fails

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