MySql选择问题

Question

我需要做一个选择，只选择 abv = "yes"和其他过滤器，比如:

SELECT *
FROM `business`
WHERE `category` LIKE ('$_GET[search]%')
OR `location` LIKE ('$_GET[search]%')
OR `name` LIKE ('$_GET[search]%')
OR `address` LIKE ('$_GET[search]%')
AND `apv`='yes'

这是行不通的，如果我把它全部放入并且不返回任何东西，另一方面，如果我放入或返回包括 apv 不同于"is"

我需要选择它:

SELECT *
FROM `business`
WHERE `category` LIKE ('$_GET[search]%')
OR `location` LIKE ('$_GET[search]%')
OR `name` LIKE ('$_GET[search]%')
OR `address` LIKE ('$_GET[search]%')

但只有 apv="yes"

Answer 1

尝试

    SELECT *
FROM `business`
WHERE (
 `category` LIKE ('$_GET[search]%')
 OR `location` LIKE ('$_GET[search]%')
 OR `name` LIKE ('$_GET[search]%')
 OR `address` LIKE ('$_GET[search]%')
)
AND `apv`='yes'