describe the problem
A list of products that needs to be displayed according to different keywords. Keywords appear in "highlight_desc | keywords | page_title | description", respectively. Such as keywords "42L large capacity", "one-click menu".
I am now searching for a keyword that has data, but if combined, there is no data. The desired result of
is that as long as the keyword is in any field, the result is displayed.
Code
$goods = D("GoodsserialView");
$where = array("goods.cate"=>$cate, "goods.status"=>1);
$keywords = "%".$keys."%";
$where["highlight_desc|keywords|page_title|description"] = array("LIKE", $keywords);