Mega Code Archive

 

Categories / MySQL / Table Index

 

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)