actions = trim(request("action")) keys = trim(request("keytext"))

来源:学生学帮网 编辑:学帮网 时间:2024/05/16 23:45:55

actions = trim(request("action")) keys = trim(request("keytext"))

sql="select top 30 * from jiaocheng where lock = false and (title like '%" & keys & "%' or neirong like '%" & keys & "%') order by jiaochengid desc
将title like 和neirong like 两个子where语句用括号括起来就可以了.