注:数据库为SQL Server
①模糊查询__在好几个字段中模糊查询某字符串
SELECT userName, name, tel, email, pwd
FROM AD_APPLY
WHERE (userName + name + tel + email + pwd LIKE '%AXzhz%')
【重点】最后一句,所有字段名用"+"连接起来.
②模糊查询＿Like和Left,,,,这两条语句执行结果相同
SELECT *
FROM bbs_forums
WHERE (LTRIM(name) LIKE '嘉年华'%')
SELECT *
FROM bbs_forums
WHERE (LEFT(LTRIM(name), 3) = '嘉年华')
【重点】Like我就不多说了,先看Left函数:
Left(要查询的列名,左起的前几个字符)='前几个字符为(二声)什么'
再看Ltrim函数,这个简单了,去除某字段的左边的空格
③SQL Server CHARINDEX和PATINDEX详解
人家写的太经典了，只能仰望＋崇敬
http://www.manbu.net/Lib/Class1/Sub10/1/15.asp