Regular Expression MySQL

  1. Home
  2. MySQL
  3. Regular Expression
  4. Group the alternatives within parentheses, the ^ and $ will apply to both of them
mysql>
mysql>
mysql> SELECT '0m' REGEXP '^([[:digit:]]+|[[:alpha:]]+)$';
+---------------------------------------------+
| '0m' REGEXP '^([[:digit:]]+|[[:alpha:]]+)$' |
+---------------------------------------------+
|                                           0 |
+---------------------------------------------+
1 row in set (0.00 sec)
mysql>