mysql - 如何使用空格和多个单词进行搜索

Question

我的搜索模块无效，因为我只搜索其中一个字段，我喜欢实现例如 Biogesic Paracetamol 组合在查询中

 if ($cat_id != 0) {
      $sqlProducts = "SELECT * FROM product  
        WHERE (PRODUCT_BRANDNAME LIKE '%$searchStr%' OR 
               PRODUCT_GENERIC_NAME LIKE '%$searchStr%') AND 
               CATEGORY_ID = $cat_id LIMIT $start_from,$num_per_page";
    }

标签： mysqlsearch

Answer 1

你应该试试：

if ($cat_id != 0) {
  $sqlProducts = "SELECT * FROM product  WHERE CONCAT(PRODUCT_BRANDNAME,PRODUCT_GENERIC_NAME) LIKE '%"+$searchStr+"%') AND CATEGORY_ID = $cat_id LIMIT $start_from,$num_per_page";
}