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