MySQL – REGEXP_INSTR() Function Table of content MySQL supports various types of pattern matching operations to retrieve filtered result-sets from huge database tables. But, pattern matching with regular expressions is a powerful way to perform a complex search. A regular expression is technically defined as a sequence of characters that represent a pattern in an […]
Category Archives: mysql
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 […]
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 […]