CODE EXAMPLE FOR SQL

mysql match in serialized data

SELECT * FROM table WHERE allData LIKE '%"xxxxxgu7@gmail.com"%' LIMIT 1;;