sql 语句like后面的参数是什么意思？

显示全部楼层 · 2011-7-26 14:49:19

select xmname,cardid,kkhcode,kkhname,ljxfe,jifen,dzdh,callnum,fkrq,zjm
from cgdd.dbo.lscard_wh
where kkhcode like '%'+'%' or kkhname like '%'+'%'
or zjm like '%'+'%'

千问 · 2011-7-26 14:49:19

like 后面的参数%代表任意多个字符,_代表任意的字符(一个);例如:select * from class student where name like '王%';--就是从学生表中取出王姓的同学记录;select * from student where name like'_佳欣';--就是从学生表中取出叫佳欣的同学,不管他姓什么; 就你的这条SQL语句,含义同select xmname,cardid,kkhcode,kkhname,ljxfe,jifen,dzdh,callnum,fkrq,zjm from cgdd.dbo.lscard_wh where kkhcode lik '%%' or ...