Regular Expression MySQL

  1. Home
  2. MySQL
  3. Regular Expression
  4. Limit the match on the i to either zero or one
mysql>
mysql> SELECT 'iaiiiiin' REGEXP 'iai?n';
+---------------------------+
| 'iaiiiiin' REGEXP 'iai?n' |
+---------------------------+
|                         0 |
+---------------------------+
1 row in set (0.00 sec)