full text search - Suay.Site

What is the difference between the LIKE operator and the equal sign (=) in MySQL/MariaDB. How to use LIKE in SQL

Posted by Alex On February 13, 2024

Table of contents 1. What to use to search in MySQL/MariaDB: LIKE operator or equals (=) operator 2. When to use equal sign (=) in SQL 3. When to use the LIKE operator in SQL 4. Even more differences under the hood Conclusion What to use to search in MySQL/MariaDB: LIKE operator or equals (=) operator The LIKE operator and...

Full-text search in MS Word files and archives in Linux

Posted by Alex On October 19, 2021

Unlike Windows, where “Full-text search for documents in a folder” is possible, Linux “out of the box” does not support full-text search in office formats. This search and indexing of office documents can be implemented using recoll package, but it requires configuration. In addition, recoll relies on pre-indexing documents, which causes problems when working with removable media: the removable media...

Full-text search in office files (Word) and archives – now it’s easy!

Posted by Alex On October 19, 2021

In the article “Full-text search for documents in a folder” we examined a way to search the contents of many office documents, including the exact match of the phrase. The considered method allows you to find the required file containing the required string without installing additional programs. But the method proposed in that note has disadvantages: search is slow, especially...

Full-text search for documents in a folder

Posted by Alex On October 19, 2021

What if you need to find a specific document among tens or hundreds? If you know the name of the document, then searching is quite simple – many programs, including the standard Windows Explorer, can search by file name. To find a file by name, open Windows Explorer (file manager), navigate to the folder where you want to search, and...