"google-like" parsing of querystring

[Anon]

Hi!

I want to improve a query for a MySQL-Database...
right now I just take a word and build a query like this
"SELECT * FROM database WHERE text LIKE '%keyword%'"
but I would like to offer people the possibility to search like this:
'word1 -word2 "phrase to search for"'

I guess more people have this problem, so I wonder it anyone has a build a customizable script for this...

Would be glad to hear from you! :-)))

Thx!
jens

[Anon]

Hi,

About the word1 -word2 bit, you can try to implement a fulltext search. If you pass me eventual miskes in the syntax, I would suggest you this type of query:

" SELECT * FROM yourdb WHERE MATCH (text) against ('+word1 -word2' IN BOOLEAN MODE) and where text like '%phrase to search for%' order by yourorderdiscipline"

vin