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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.