查找uname字段中以'st'为开头的所有数据:
SELECT uname FROM cu_user WHERE uname REGEXP '^st';
SELECT uname FROM cu_user WHERE uname like 'st%';
查找uname字段中以'ok'为结尾的所有数据:
SELECT uname FROM cu_user WHERE uname REGEXP 'ok$';
SELECT uname FROM cu_user WHERE uname like '%ok';
查找uname字段中包含'mar'字符串的所有数据:
SELECT uname FROM cu_user WHERE uname REGEXP 'mar';
查找uname字段中以元音字符开头且以'ok'字符串结尾的所有数据:
SELECT uname FROM cu_user WHERE uname REGEXP '^[aeiou]|ok$';
查找uname字段中以'st'为开头以'ok'为结尾的所有数据:
SELECT uname FROM cu_user WHERE uname like 'st%ok';