SELECT * FROM table WHERE json LIKE `%"field":"value"%`; and pray the json doesn't have any spaces.