Hello.
To search for `\', specify it as `\\\\' (the backslashes are stripped once by the parser and another time when the pattern match is done, leaving a single backslash to be matched). Steve Buehler <[EMAIL PROTECTED]> wrote: > I am trying to find everything in a column that has a backslash in it and > the select statement that I am trying to use doesn't find any of them. My > statement is: > SELECT * FROM `team` WHERE `name` LIKE '%\%' > > I have also tried: > SELECT * FROM `team` WHERE `name` LIKE '%\\%' > > Any idea how to search for a backslash in a column of a table? > > Thanks > Steve > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]