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` ,'%'))