Regular Expression MySQL

  1. Home
  2. MySQL
  3. Regular Expression
  4. If you wish to encompass the entire character string, you must use ^ and $ in the search
mysql>
mysql>
mysql> SELECT 'abc' REGEXP '^abc$', 'abcabc' REGEXP '^abc$';
+----------------------+-------------------------+
| 'abc' REGEXP '^abc$' | 'abcabc' REGEXP '^abc$' |
+----------------------+-------------------------+
|                    1 |                       0 |
+----------------------+-------------------------+
1 row in set (0.00 sec)
mysql>