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 […]
Author Archives: user
MySQL – REGEXP_LIKE() 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. As we have seen in the previous chapter, the MySQL regexp_instr() function is used to return the […]
MySQL – NOT REGEXP Operator Table of content MySQL NOT REGEXP Operator Technically, a regular expression is defined as a sequence of characters that represent a pattern in an input text. It is used to locate or replace text strings using some patterns; this pattern can either be a single character, multiple characters or words, […]