Select * FROM table Where id > 0 AND( CONCAT_WS(' ',field1,field2,field3,field4,field5) LIKE '%key1%' or CONCAT_WS(' ',field1,field2,field3,field4,field5) LIKE '%key2%' ) orDER BY field ASC
Select * FROM table Where CONCAT_WS(' ',field1,field2,field3,field4,field5) LIKE '%key1%' or CONCAT_WS(' ',' ',field1,field2,field3,field4,field5) LIKE '%key2%' orDER BY field ASC
[code="java"]程序代码 ######################################联合查询#####################################select table.* from tableleft join table ontable.id in (Select id FROM table where id=3...