## Find text of one column in another

We’re writing a game where the target word must be in the phrases and sentences. To make sure that this happens, I used this code to find the targets not in the phrase.


SELECT * FROM ArticIV_ShowMe WHERE !(phrase  LIKE CONCAT('%', target ,'%'))