Can I parse a text value from a specific column in a query (MySQL)?
WITHOUT INDEXING

SELECT * FROM actor_info
WHERE film_info LIKE '%Animation%' OR film_info LIKE '%Documentary%';


or

SELECT * FROM actor_info
WHERE LOCATE('Animation',film_info)&gt;0
OR LOCATE('Documentary',film_info)&gt;0;


WITH INDEXING

Create a FULLTEXT index on film_info

ALTER TABLE actor_info ADD FULLTEXT (film_info);


Query using the FULLTEXT index

SELECT * FROM actor_info
WHERE MATCH (film_info) AGAINST ('+Animation*' IN BOOLEAN MODE)
UNION
SELECT * FROM actor_info
WHERE MATCH (film_info) AGAINST ('+Documentary*' IN BOOLEAN MODE);