MySQL – REGEXP_SUBSTR() Function Table of content Regular expressions in MySQL are used in search operations to filter and retrieve records from a database table that match specified patterns. This process of detecting patterns in a set of data is known as pattern matching. It is helpful whenever the data is considered to have similar […]
Category Archives: mysql
MySQL – Boolean Full-Text Search Table of content MySQL Boolean Full-Text Search The MySQL provides a full-text search functionality that supports three types of searches, one of which is the Boolean full-text search. This Boolean full-text search enables complex search operations on large amounts of text data, by allowing the use of Boolean operators such […]
MySQL – Natural Language Fulltext Search Table of content Before we fully get into the concept of Natural Language Full-text Search, let us try to understand the context of it. Nowadays, the keywords used for searches might not always match the results that users expect. So search engines are designed to focus on increasing search […]