SQL Query question

[Benpsycho]

I want to create a query that checks if a part of an entered string is allready in the database. e.g.

This is my string: nfgdfTESTsdgdsf

In the database there is an entry with: TEST

So it would return this row..

I tried some combinations with LIKE and % wildcards but it didn't work out. It would be easy todo it the other way round e.g.:

SELECT * FROM table WHERE field LIKE '%string%'
but that's the oppsite of what I want to do..

Any help is greatly appreciated. Thx alot

[LordShryku]

That's a fairly odd request. Is this portion of the string constant? Or do you want to search for everything contained in the whole string (records containing 'nfg', 'n', 'f', 'g', 'nf', 'fg', etc)?

[Benpsycho]

Well it's for a forum. For new threads a check should be made to see if any word in the title is part of a 'list' of words.
This 'list' of words is another database table.

As result I wan't the row of the word list table, if there are any results.

So it has to look a bit Like:

Select * From wordlist WHERE word ?part of? $new_thread_title

[Benpsycho]

I found the solution it works with the mysql function INSTR