full text search - Suay.Site

How to find rows with empty column value in MySQL/MariaDB table (in phpMyAdmin and in command line)

Posted by Alex On August 16, 2024

How to find rows with empty column value in phpMyAdmin Suppose you want to find rows in a table where the value of a certain column is empty. To do this, you try to use the table search in phpMyAdmin. If you go to the “Search” tab in phpMyAdmin and click the “Go” button without entering any values (since you...

PHP regular expressions don’t work with very long strings (SOLVED)

Posted by Alex On August 13, 2024

preg_replace, preg_match_all, and preg_match functions don't work with long strings When trying to search in PHP using regular expressions using preg_replace, preg_match_all, and preg_match (or other regular expression search functions), the following problem may occur: the string being searched for exactly contains a substring that matches the search pattern; but instead of outputting the matched strings, the function finds nothing....

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