Regular Expression MySQL

  1. Home
  2. MySQL
  3. Regular Expression
  4. To get the equivalent with LIKE, youd have had to use % wildcards at the end
mysql>
mysql> SELECT 'abcdef' LIKE 'abc%';
+----------------------+
| 'abcdef' LIKE 'abc%' |
+----------------------+
|                    1 |
+----------------------+
1 row in set (0.00 sec)
mysql>