NYCPHP Meetup

NYPHP.org

[nycphp-talk] escaping % and _ in a MySQL query

Daniel Convissor danielc at analysisandsolutions.com
Sun Oct 31 11:58:29 EST 2004


Hey David:

Do note, the official way to escape items in a LIKE clause is:

   select * from FOO where cf like 'a^%%' escape '^'

--Dan

-- 
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
            data intensive web and database programming
                http://www.AnalysisAndSolutions.com/
 4015 7th Ave #4, Brooklyn NY 11232  v: 718-854-0335 f: 718-854-0409



More information about the talk mailing list