mysql contains certain strings from another table -

mysql contains certain strings from another table -

i have 2 tables: first table contains list of strings sec table contains name , description

i want in mysql list of strings of first table contained in description of particular line of sec table.

for example: firsttable(string):

sam thierry chris

secondtable (name | description):

first | sam , brother of chris sec | thierry

i want list contains:

sam chris

if select first line of secondtable.

is possible?

query select firsttable.* firsttable, secondtable locate(firsttable.`string`, secondtable.`description`) > 0 , name='first'; demo

mysql