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 […]
Author Archives: user
MySQL – Full-Text Search Table of content The MySQL Full-Text Search allows us to search for a text-based data, stored in the database. Before performing the full-text search in a column(s) of table, we must create a full-text index on those columns. The FTS (full-text search) provides the capability to match the searched string value […]
MySQL – REGEXP_REPLACE() Function Table of content Regular expressions in MySQL are used in search operations to not only filter records but also replace the pattern occurrences in a string. Consider a scenario where you noticed a spelling error among the huge sets of data present in a MySQL database. Now, you are supposed to […]