Find double qoutes inside a string which is in double quotes in mysql
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 ('').