hey guys

I wanna write some script to search a mysql database. by giving key words.

anywhere i could find a perfect search pattern? I mean to see how it analyze the words and how it search all the table for it ?

Thanks

No idea what you mean by "a perfect search pattern". You have a keyword? You can search for it in field P by using

P LIKE '%keyword%'

But there is also a mysql "full text search" function.

Not sure if this helps, but perhaps you could rephrase the question.

actually there is some kind of search already running. But it works so bad,. For example it doesn't show anything if your keywords is more than 2 words. it has a lot of problems. tht i want to rewrite all.

i was wondering how other websites search field , search whole database ... ( or how they treat the keywords?)