Need help on mysql query

[Casey Chau]

Hi All,

I'm new to the forum. Greetings to all here.

I've a problem in writing a query statement. Please give me some advice for such a helpless newbie !!!

I've a table with all company name, with id
e.g.
id Name
--------------
1 ABC company
2 DEF company
3 XZY company

And I have a string that contains some company name,
e.g. 'ABC company is working on a project with DEF company'

I would like to search all company name in the string that exist in the table
So I will ABC company and DEF company in the above case.

I've think of using % but seem doesn't work. Could anyone give me some advice

Many Thanks