Category Archives: mysql

MySQL – RLIKE Operator Table of content MySQL RLIKE Operator The RLIKE operator in MySQL is used to search data in a database using patterns (or regular expressions), also known as pattern matching. In other words, the RLIKE operator is used to determine whether a given regular expression matches a record in a table or […]

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 […]

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, […]