SQL实现模糊字段查询，去空版

iteye_13003

于 2011-05-01 10:29:20 发布

阅读量126

点赞数

CC 4.0 BY-SA版权

文章标签： SQL

本文链接：https://blog.youkuaiyun.com/iteye_13003/article/details/82060644

select * from UTUser
where (username like '%第一个textbox的值%' and len(username) > 0) or (password like '%第二个textbox的值%'
 and len(password) > 0) or  (lasttime like '%第三个textbox的值%' and len(lasttime) > 0)
 or  (usertype like '%第四个textbox的值%' and len(usertype) > 0)