SQL4

SELECT * FROM employee WHERE name REGEXP ‘^ale‘;

SELECT * FROM employee WHERE name REGEXP ‘on$‘;

SELECT * FROM employee WHERE name REGEXP ‘m{2}‘;


小结：对字符串匹配的方式
WHERE name = ‘egon‘;
WHERE name LIKE ‘yua%‘;
WHERE name REGEXP ‘on$‘;

SQL4

标签：之间   排序   toolbar   过滤   distinct   注意   逻辑运算   执行   字段