Advertisement
Guest User

Untitled

a guest
Dec 19th, 2014
162
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. the problem is backslashes in LIKE expressions on mysql
  2. when the parameter is in a WHERE x = ? it needs to be 'Contain\\ABackslash'
  3. but when its WHERE x LIKE ? the parameter needs to be 'Contain\\\\ABackslash'
  4. so mysql expectes 8 \ instead of the given 4 when representing a backslash in a LIKE expression
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement