operators – Page 23

How the LIKE Operator Works in MySQL

February 14, 2020April 24, 2019 by Ian

In MySQL, the LIKE operator performs pattern matching using an SQL pattern.

If the string matches the pattern provided, the result is 1, otherwise it’s 0.

The pattern doesn’t necessarily need to be a literal string. This function can be used with string expressions and table columns.

How NOT RLIKE Works in MySQL

November 19, 2019April 19, 2019 by Ian

In MySQL, NOT RLIKE is a negation of the RLIKE operator.

In other words, any time the RLIKE operator would return 1, NOT RLIKE will return 0.

How NOT REGEXP Works in MySQL

February 14, 2020April 19, 2019 by Ian

In MySQL, NOT REGEXP is a negation of the REGEXP operator.

In other words, if the string matches the regular expression provided, the result is 0, otherwise it’s 1. This is the opposite result to what the REGEXP would return (when it isn’t prefixed with NOT).

How the RLIKE Operator Works in MySQL

February 14, 2020April 18, 2019 by Ian

In MySQL, the RLIKE operator is used to determine whether or not a string matches a regular expression. It’s a synonym for REGEXP_LIKE().

If the string matches the regular expression provided, the result is 1, otherwise it’s 0.

MySQL REGEXP Examples

November 19, 2019April 15, 2019 by Ian

In MySQL, the REGEXP operator is used to determine whether or not a string matches a regular expression. It’s a synonym for REGEXP_LIKE().

If the string matches the regular expression provided, the result is 1, otherwise it’s 0.