https://www.mysqltutorial.org/mysql-boolean-text-searches.aspx
| Operator | Description | Example |
| + | A leading plus sign indicates that a word must be present in each row that is returned. | '+join +union'
Find rows that contain both words.
'+join union'
Search rows that contain the word 'join', but rank rows higher if they also contain 'union' |
| - | A leading minus sign indicates that a particular word must not be present in any of the rows that are returned. The - operator acts only to exclude rows that are otherwise matched by other search terms. | '+join -union'
Find rows that contain the word 'join' but not 'union'. |
| (no operator) | By default, the word is optional, but the rows that contain it are rated higher. | 'join -union'
Search rows that contain at least one of the two words. |
| > < | These two operators are used to change a word's contribution to the relevance value that is assigned to a row. The > operator increases the contribution and the < operator decreases it. | '+join +(>left <right)'
Find rows that contain the words 'join' and 'left' or 'join' and 'right' (in any order), but rank 'join left' higher than 'join right'. |
| ( ) | Parentheses group words into subexpressions. Parenthesized groups can be nested. | |
| ~ | A leading tilde acts as a negation operator, causing the word's contribution to the row's relevance to be negative. | '+join ~left'
Find rows that contain the word 'join', but if the row also contains the word 'left', rate it lower than if row does not. |
| * | The asterisk serves as the truncation (or wildcard) operator. Unlike the other operators, it is appended to the word to be affected. Words match if they begin with the word preceding the * operator. | 'join*'
Find rows that contain words such as 'join', 'joins', 'joining' etc. |
| " | A phrase that is enclosed within double quote (“"”) characters matches only rows that contain the phrase literally, as it was typed. | '"left join"'
Find rows that contain the exact phrase "let join". |
LBD: manobiblija.lt
DŠ prisijungimas nemokamai: dale@lcn.lt / p: mBib20dss
TŽ: https://newchristianbiblestudy.org/bible/lithuanian/genesis/1/
Burbulio: http://www.ebiblija.lt/
You Bible: https://www.bible.com/languages/lit - LDB eku, LBD su II kanonu; TŽ :
Vertimai pagalbinės medžiagos:
https://bibleproject.com/Lithuanian/