Find double qoutes inside a string which is in double quotes in mysql I'm storing a string that includes, by necessity, double quotes, e.g.:

ID           Data
1   "This is "my" example." 
2   "This is my example."


I want to find only those row which are like ID 1. How can i do this. 

"This is "my" example." (I know it's hard to tell the difference here)

Please suggest.
select * from table
where data like '"%"%"'


Or you could compare the length of data against the length of data when '"' is replaced with an empty string ('').