Search Query

[Highlander]

Hello @ all

i have a thing wich is needed to manage it somehow.

i have a table named "ae_articles" and in this table i want to search for related topics "title"

so the normal way for a simple search is

SELECT from ae_articles WHERE title LIKE %topic_title_var% ..but this dont works for me .. cause the "topic_title_var" will do a search for only the same .. topic title

for exapmple i have to topics:
Nvidia - Geofrce 6800 releases
Nvidia - Gerforce 6200 for mainstream availayble now

how to create a topic wich will search for this releations? When i look in the topc #1 i can call out the topic title oif it in a variable .. so but the search qeury would work best , when only one word or the first word would be used for a "LIKE" search query?!

any idea .. i dont know how to split the topic titles into one word or more words for search query

greetings
dan

[Andreas]

SOUNDEX() might help.

> any idea .. i dont know how to split the topic titles into one word or more words for search query

PHP Code:

$topic_words = explode(' ', $topic);
$firstword = $topic_words[0]; 


Assuming that $topic always has at least one word this should work.