select * from name like '%李%' select * from name like '李?'就像DOS里面的 dir *李* dir 李?
select * from table where name like 's%' 列出所有以S开头的记录 select * from table where name like 's?' 列出所有以S开头,两个字符长度的记录
select * from table like '%name%'=dos: dir *name* select * from table like 'name?'=dos:dir name??
select * from table 列出table里的所有记录
select * from table where name like "dir%" 相当于:dir dir* select * from table where name like "%dir%"相当于:dir ?dir* select * from table where name like "dir?" 相当于:dir dir?
select * from name like '李?'就像DOS里面的
dir *李*
dir 李?
select * from table where name like 's?' 列出所有以S开头,两个字符长度的记录
select * from table like 'name?'=dos:dir name??
select * from table where name like "%dir%"相当于:dir ?dir*
select * from table where name like "dir?" 相当于:dir dir?