Notice that if a user enters

"life anger"

in the search field

SELECT * FROM table WHERE question LIKE "%life anger%" none of the

>> [1] How do you deal with anger?
>> [2] Ever been full of anger in your life?
>> [3] Is life always easy?

will match. For that you must split the query by " " and perform a

SELECT * FROM table WHERE question  LIKE "%life%" OR question LIKE

or possibly change the OR with a AND.

Kind regards,
    Morten Winkler

PHP General Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to