Search commandsFor search in forum we use MySQL full text search features in boolean mode. You can read about it in MySQL documentation.
But here I put some examples:
- apple banana
Find rows that contain at least one of the two words. - +apple +juice
Find rows that contain both words. - +apple macintosh
Find rows that contain the word “apple”, but rank rows higher if they also contain “macintosh”. - +apple -macintosh
Find rows that contain the word “apple” but not “macintosh”. - apple*
Find rows that contain words such as “apple”, “apples”, “applesauce”, or “applet”. - "some words"
Find rows that contain the exact phrase “some words” (for example, rows that contain “some words of wisdom” but not “some noise words”).
|