KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
My company runs MySQL in NO_BACKSLASH_ESCAPES mode. How can I escape a literal % or _ in a LIKE query in this mode? The standard way is \% , but that doesn't work in this mode. Example: a column has the following values: 5% off , 50% off . The following query works in standard mode but not in NO_BACKSLASH_ESCAPES mode: SELECT * FROM mytable WHERE mycol LIKE '5\% off'
Tags (comma-separated)
Save Edits
Cancel