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

"Peter P. Benac" <[email protected]>
Newsgroups gmane.comp.db.mysql.perl
Message-ID <[email protected]>
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:[email protected]] 
Sent: Tuesday, November 09, 2004 5:03 AM
To: [email protected]
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



-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.