I'd like to use sql with special char to search list such as select * from test where name like "%_%" but this will also search - and _, so how can I deal with it? and how about char % or ?
I'd like to use sql with special char to search list such as select * from test where name like "%_%" but this will also search - and _, so how can I deal with it? and how about char % or ?