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

You must be logged in to post a comment.

Well Golly


Atheism Plus

Buy from Amazon