SQL模糊查找

编辑器加载中... /*********************实现模糊查找**************************/ SELECT [UserId] ,[UserName] ,[UserLoginName] ,[UserLoginPwd] ,[RoleId] FROM [DBDemo].[dbo].[tblUser] --****************[%]转义******************** where username like '%[%]' SELECT [UserId] ,[UserName] ,[UserLoginName] ,[UserLoginPwd] ,[RoleId] FROM [DBDemo].[dbo].[tblUser] where CHARINDEX ('%',username)>0----------模糊查找 PRINT CONVERT(VARCHAR,GETDATE(),23)------------显示时间