Having now read your conversation with Emux on Github I understand that you can read SQL, so let's be a little bit more technical
For a search like 'keyword_1 keyword_2', this will generate the following SQL
for the same keywords, but without quotes, search would be
If the user select the option to search for any of the keywords
Bonus track, undocumented trick that Jose told me about:
you can search for key/value pairs. For doing so you must put an equal sign in between i.e email=abc@xyz.com. But there is a gotcha, this will generate the following SQL
Look at the % character (SQL wildcard) after the equal sign, this means that this search will return records containing 'abc@xyz.com' anywhere AFTER 'email='. It is done on purpose to allow find partial values as well. If the real email address is '123.abc@xyz.com', it will be found.
Hope this helps
QuoteTo search for the exact text, all the words and in the same order, it must be enclosed in single or double quotes
For a search like 'keyword_1 keyword_2', this will generate the following SQL
Code Select
... WHERE data LIKE '%keyword_1 keyword_2%'QuoteIf the text is not enclosed in quotes, results containing all the words will be searched regardless of the order
for the same keywords, but without quotes, search would be
Code Select
... WHERE data LIKE '%keyword_1%' AND data LIKE '%keyword_2%'Quoteor any of them if that option is selected
If the user select the option to search for any of the keywords
Code Select
... WHERE data LIKE '%keyword_1%' OR data LIKE '%keyword_2%'Bonus track, undocumented trick that Jose told me about:
you can search for key/value pairs. For doing so you must put an equal sign in between i.e email=abc@xyz.com. But there is a gotcha, this will generate the following SQL
Code Select
... WHERE data LIKE '%email=%abc@xyz.com%'Look at the % character (SQL wildcard) after the equal sign, this means that this search will return records containing 'abc@xyz.com' anywhere AFTER 'email='. It is done on purpose to allow find partial values as well. If the real email address is '123.abc@xyz.com', it will be found.
Hope this helps