MySQL Forums
Forum List  »  Quality Assurance

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

Hello,
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.

Thanks,
Rami

Options: ReplyQuote


Subject
Views
Written By
Posted
optimized Boolean Full-Text Search
1952
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.