sql通配符

(1)    ‘_’代表一个字符

Select * from student where name like’_my%’

---查找name中第二第三个字符为my的数据

(2)    ‘[]’代表包含

Select * from student where name like’[ACD]%’

---查找name中以A/C/D开头的所有数据