MySql , Select with special Character

user_19748133 0
Viewed 38

so i have a table with this data, but when i query "select * from assetprofile WHERE description1='(1) GENSET\FOR ATM' ", it shows nothing . any help?

enter image description here

mysql sql
3 Answers

Try use IN operator:

SELECT * from assetprofile WHERE description1 IN ('(1) GENSET\FOR ATM')
user_166238160

The sample data does not have a space between the parentheses and GET, but your query does.

user_40201980

Try to escape the string using QUOTE function:

SELECT * FROM assetprofile WHERE description1 = QUOTE('(1) GENSET\FOR ATM');
user_89493650
Related