[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