Regular Expression MySQL

  1. Home
  2. MySQL
  3. Regular Expression
  4. A regular expression matches anywhere in the string
mysql>
mysql> SELECT 'abcdef' REGEXP 'abc';
+-----------------------+
| 'abcdef' REGEXP 'abc' |
+-----------------------+
|                     1 |
+-----------------------+
1 row in set (0.00 sec)
mysql>
mysql> SELECT 'abcdef' LIKE 'abc';
+---------------------+
| 'abcdef' LIKE 'abc' |
+---------------------+
|                   0 |
+---------------------+
1 row in set (0.00 sec)
mysql>