problem with mysql query when password like \/'

Question

In mysql table name (user_login) and i having field like login_name and password . I entered in login_name as abc and password as \/'(Special symbols like \ / ') .And my query is

select password from user_login where password like '\/'' and I got sql syntax error

Answer 1

You should use parameterised queries in what ever language you are implementing the call in. Beware SQL Injection attack

Answer 2

hi you should use parameters instead of putting varibles directly into the query. i think it's aproblem with the escaping symbol.

check out this link http://stackoverflow.com/questions/1294974/how-to-set-query-parameters-in-mysql-query-browser