MySQL – NOT LIKE Operator Table of content MySQL NOT LIKE Operator We have previously learned that the LIKE Operator in MySQL database is a logical operator used to perform pattern matching operation on a database table. And NOT LIKE Operator is defined as opposite of this LIKE operator. Both LIKE and NOT LIKE operators […]
Category Archives: mysql
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, […]
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 […]