^ beginning
$ end
| logical or
[abcd]
[a-f]
1,REGEXP是regular expression 正则表达式的缩写
where last_name like '%field%'等于where last_name regexp'field'
结果都是
2,
- where last_name regexp'^field':field开头的lastname
- where last_name regexp'field$':field结尾的lastname
- where last_name regexp'field|mac':含有field或者Mac的lastname
- where last_name regexp'field|mac|rose':含有field或者Mac或者rose的lastname
- where last_name regexp'^field|mac|rose':以field开头,或者包含Mac或者包含rose这三种情况的lastname,因为field开头的人没有,所以只存在2个人符合条件
- where last_name regexp'field$|mac|rose':这时候就有三个符合条件的了
3,
- select *
from customers
where last_name regexp'[gim]e':lastname中含有e,且g or i or m在前面 - where last_name regexp'e[gim]':lastname中含有e,且g or i or m在后面
- where last_name regexp'[a-h]e':lastname中含有e,且a-h的任何字母在前面
4,从customers的表中做四个练习
select *
from customers
where first_name regexp'elka|ambur'
PS:
where first_name like'elka' or
first_name like'ambur'这个也行的
where first_name regexp'elka' or
first_name regexp'ambur'这个也行的
2.
select *
from customers
where last_name regexp 'EY$' OR last_name regexp 'ON$'
(最后一句简化成:where last_name regexp'EY$|ON$')
3.
select *
from customers
where last_name regexp'^mY'OR last_name regexp'se'
(最后一句简化成:where last_name regexp'^my|se')
4.
select *
from customers
where last_name regexp'b[ru]'
最后一句也可以写成:where last_name regexp'br|bu'