mysql serialized data code example

Example: mysql match in serialized data

SELECT * FROM table WHERE allData LIKE '%"[email protected]"%' LIMIT 1;;