基本SQL子查询

您只需要对您的条件进行分组，

SELECt  ...FROM    ...WHERe   (a.`id` = b.`id`) AND        (   b.`product-id` LIKE "%car%" OR   b.`name` LIKE "%car%" OR   b.`branch` LIKE "%car%" OR   b.`description` LIKE "%car%"        )