SQL like用法

Question

在语句中,使用where 条件时,用like限定字段小于等于'00%'
应该怎么表达!~
au_ID au_name
01 s
0101 k
0102 u
0201 w
0202 y
select * from master where au_ID<=03
想查询出所有带有01,02,03的行,
如何实现?

Answer 1

select * from master where substring(au_ID,1,2)<='03'

Answer 2

select * from master where substring(au_ID,1,2)<='03'
and substring(au_ID,1,2)>='01'

Answer 3

select * from master where au_ID like '%01%' or au_ID like '%02%' or au_ID like '%03%'

Answer 4

最简单的写法
select * from master where au_id like '%0[1-3]%'