Well, first rule – you should not do this. But if there is good reason, consider using such query for searching in index-based arrays: SELECT * FROM table … Continue reading How to use MySQL to search in php serialized fields