MySQL Forums
Forum List  »  Quality Assurance

optimized Boolean Full-Text Search
Posted by: Rami Q.
Date: September 07, 2011 04:32PM

is there any better way to write a String Query than the following(which returns exactly what i need, but maybe there is a better way for the same issue)?

>("motor bmw") >(+"motor" +"bmw") <(+(*motor*) +(*bmw*))

prio 1 for rows which contain "motor bmw"
prio 2 for rows which contain "motor" AND "bmw"
prio 3 for rows which contain these two words as SubStrings

i don't want rows which contains only one of these words

Sorry for my English.


Options: ReplyQuote

Written By
optimized Boolean Full-Text Search
September 07, 2011 04:32PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.