ufd働く美女系列:select from where like

来源：百度文库编辑：高考问答时间：2024/04/28 00:04:13

sql="select * from list_view where view_type and view_ok2 or netesa or netesb or netesc or netesd or netese or netesf or netesg or netesh or netesi or netesj or netesl or netesk like '%"&key_keyword&"%' ORDER BY ID desc"
上述语句出现检索不到Access数据库list_view表里view_type view_ok2 netesa netesb ...netesk字段名称内的内容. (view_type view_ok2 netesa netesb ...netesk 是 list_view 表里的字段名称) (list_view表名称) ('%"&key_keyword&"%'检索"关键词")

你的意是不是查找表 list_view 里的 (view_type view_ok2 netesa netesb ...netesk) 这些字段里有关键字 key_keyword 的记录是不是。如果是这样最好是这样写：
sql="select * from list_view where view_type like '%"&key_keyword&"%' and view_ok2 like '%"&key_keyword&"%' and …… netesk like '%"&key_keyword&"%'"
这样写下来。你上面那种方法是错的。
sql="select * from list_view where view_type and view_ok2 or netesa or netesb or netesc or netesd or netese or netesf or netesg or netesh or netesi or netesj or netesl or netesk like '%"&key_keyword&"%' ORDER BY ID desc"
这个意思是查找表list_view 里字段 view_type = True and view_ok2 = True and …… or netesk like '%"&key_keyword&"%' ORDER BY ID desc"
这是where子句的理解错误，以后注意就OK了。

select from where like select sum(*) from...where..... select * from table1 where id in (select id from table2)， select from where like 求助帮忙 select * from buy where id= 261 select * from forums where type<>'category' SELECT @CNT=COUNT(*) FROM TABLE1 WHERE [NAME]= @ADDRNAME sql="select * from asdfghj where username='admin'" sql="select * from 表名 where 一个字段名称='中文 sql1 ="select * from news where feilei="& request("feilei")