SELECT * FROM userinfo WHERE charindex('1390887',usertel)>0 OR charindex('1390887',userinfo)>0
SELECT * FROM userinfo where charindex('1390887',usertel) >0 or charindex('1390887',userinfo) > 0
try: SELECT * FROM userinfo WHERE PATINDEX('%1390887%',usertel)>0 OR PATINDEX('%1390887%',userinfo)>0
楼上均可得到结果,建议用 charindex()
为什么要用charindex 不用like ,难道charindex 效率高一些么
方法一: select username,usertel,userinfo from userinfo where usertel like '%1390887% or userinfo like '%1390887%' 方法二: SELECT * FROM userinfo WHERE charindex('1390887',usertel)>0 OR charindex('1390887',userinfo)>0
修改方法一: select username,usertel,userinfo from userinfo where usertel like '%1390887%' or userinfo like '%1390887%'
SELECT * FROM userinfo WHERE charindex('1390887',usertel)>0 OR charindex('1390887',userinfo)>0效率好一些。
charindex LIKE效率基本差不多
charindex() 稍微快一点点 其实也基本差不多
SELECT * FROM userinfo WHERE charindex('1390887',usertel)>0 OR charindex('1390887',userinfo)>0
SELECT * FROM userinfo WHERE charindex('1390887',usertel)>0 OR charindex('1390887',userinfo)>0
where charindex('1390887',usertel) >0 or charindex('1390887',userinfo) > 0
SELECT * FROM userinfo WHERE PATINDEX('%1390887%',usertel)>0 OR PATINDEX('%1390887%',userinfo)>0
select username,usertel,userinfo from userinfo where usertel like '%1390887% or userinfo like '%1390887%'
方法二:
SELECT * FROM userinfo WHERE charindex('1390887',usertel)>0 OR charindex('1390887',userinfo)>0
select username,usertel,userinfo from userinfo where usertel like '%1390887%' or userinfo like '%1390887%'
其实也基本差不多