table2是结果集?用一条不就可以了吗 SELECT * FROM table1 WHERE type <> '2' && (name_type between 1 and 2) and name like "%$keyword%" name,details,info like "%$keyword%" 这是什么数据库的写法?
可以这样写么? SELECT * FROM table1 WHERE type <> '2' && (name_type between 1 and 2) and name,details,info like "%$keyword%" 表示根据这3列进行keyword模糊匹配
select * from (SELECT * FROM table1 WHERE type <> '2' && (name_type between 1 and 2)) where name,details,info like "%$keyword%" && 换成and 试下
SELECT * FROM table1 WHERE type <> '2' and (name_type between 1 and 2) and name like %$keyword% and details like %$keyword% and info like %$keyword%
SELECT * FROM table1 WHERE type <> '2' && (name_type between 1 and 2) and name like "%$keyword%" name,details,info like "%$keyword%" 这是什么数据库的写法?
SELECT * FROM table1 WHERE type <> '2' && (name_type between 1 and 2) and name,details,info like "%$keyword%" 表示根据这3列进行keyword模糊匹配
from (SELECT * FROM table1 WHERE type <> '2' && (name_type between 1 and 2))
where name,details,info like "%$keyword%" && 换成and 试下