Regular Expression MySQL

  1. Home
  2. MySQL
  3. Regular Expression
  4. The command REGEXP offers many more possibilities for formulating a pattern
mysql>
mysql> SELECT 'abcabc' REGEXP 'abc', 'abcabc' REGEXP 'cb';
+-----------------------+----------------------+
| 'abcabc' REGEXP 'abc' | 'abcabc' REGEXP 'cb' |
+-----------------------+----------------------+
|                     1 |                    0 |
+-----------------------+----------------------+
1 row in set (0.00 sec)