Find double quotes in MySQL column

Question

I want to find data with double quotes. I have the next simple query:

SELECT * FROM table_name WHERE column_name LIKE "%\"%";

But I have syntax error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"%\"%' at line 1

What should I do to find this data with double quotes(")?

use [`REGEXP`](http://dev.mysql.com/doc/refman/5.0/en/regexp.html#operator_regexp) instead — xkeshav, Dec 26 '11 at 07:18
http://stackoverflow.com/questions/881194/how-to-escape-special-character-in-mysql — Wael Dalloul, Dec 26 '11 at 07:21

score 16 · Accepted Answer · edited May 23 '17 at 12:07

Because the \ character is used by the LIKE operator itself you have to double it when you use it to escape another character like the double quote.

see here

SELECT * FROM table_name WHERE column_name LIKE "%\\"%";

should work for you.

as will changing out the double quotes for single quotes to enclose the literal

SELECT * FROM table_name WHERE column_name LIKE '%"%';

as you posted here

score 3 · Answer 2 · answered Dec 26 '11 at 07:19

3

try

SELECT * FROM table_name WHERE column_name LIKE '%"%';

answered Dec 26 '11 at 07:19

xkeshav

53,360
44
177
245

score 2 · Answer 3 · answered Dec 26 '11 at 07:29

2

SELECT * FROM table_name WHERE column_name LIKE '%\"%'; this one is work.Check it.

answered Dec 26 '11 at 07:29

score 1 · Answer 4 · answered Dec 26 '11 at 07:17

1

Sorry, I have found the answer:

SELECT * FROM table_name WHERE column_name LIKE '%"%';

answered Dec 26 '11 at 07:17

Alex Pliutau

21,392
27
113
143

score 0 · Answer 5 · answered May 29 '17 at 11:51

0

If in database fields has both single and double quotes then in query follow below syntex:

"select id,name 
from table_name 
where 
Replace(
Replace(name, \"'\", '`' ),'\"','`')='".value."'

answered May 29 '17 at 11:51

Yuvraj Singh Shekhawat

313
2
15

Find double quotes in MySQL column

5 Answers5

Linked