Table Index MySQL

  1. Home
  2. MySQL
  3. Table Index
  4. Use the asterisk to try matching against the name ian or the alternative spelling, iain
mysql>
mysql> SELECT 'ian' REGEXP 'iai*n';
+----------------------+
| 'ian' REGEXP 'iai*n' |
+----------------------+
|                    1 |
+----------------------+
1 row in set (0.00 sec)