MySQL find result that is substring of a query string

Question

I have a query string like This is a computer. And I have some words in database like computer, This, machine.

I want to find the words which are the substrings of the query string. For the example above, I will get This and computer.

How to write the mysql statement?

Rahul · Accepted Answer · 2014-10-02 11:46:20Z

3

You can do something like below using INSTR() function

SELECT * FROM your_table
WHERE INSTR('This is a computer', word) > 0

answered Oct 2, 2014 at 11:46

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

fancyPants · Accepted Answer · 2014-10-02 11:39:46Z

1

SELECT
words
FROM
table_with_words
WHERE 'This is a computer' LIKE CONCAT('%', words, '%');

answered Oct 2, 2014 at 11:39

fancyPants

52.1k34 gold badges94 silver badges100 bronze badges

mochalygin · Accepted Answer · 2014-10-02 11:56:52Z

0

If you have many words in table, mb, preferable will be using of such query:

SELECT word
FROM table_with_words
WHERE FIND_IN_SET(word, REPLACE('This is a computer', ' ', ',')) != 0

answered Oct 2, 2014 at 11:56

mochalygin

7421 gold badge6 silver badges14 bronze badges