MySql Select problem

Question

I need to do a select that select only the abv = "yes" and other filters,like:

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'

This is not working, if I put it all AND does not return anything, on the other hand if I put OR returns including the apv is different from "yes"

I need to select it:

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

But only with apv="yes"

Not directly related to the question but please be careful about SQL injection vulnerabilities. The dynamic SQL in this question has a big security hole. — Asaph
– Asaph, Commented Sep 30, 2009 at 21:41

Gratzy · Accepted Answer · 2009-09-30 21:37:05Z

2

Try

    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'

answered Sep 30, 2009 at 21:37

Gratzy

9,4174 gold badges32 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ennuikiller · Accepted Answer · 2009-09-30 21:38:23Z

2

Did you try putting parens around the or clauses?

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'

answered Sep 30, 2009 at 21:38

ennuikiller

47.1k15 gold badges115 silver badges137 bronze badges

Collectives™ on Stack Overflow

MySql Select problem

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related