MySQL query with LIKE

Question

I have problem with this query.

SELECT id, zadane, firma, nazov, miesto, ukoncenie
FROM praca
WHERE LOWER( nazov ) LIKE '%administratívny pracovník, referent%'
AND potvrdena =1
AND LOWER( miesto ) LIKE '%bratislavský kraj%'
OR LOWER( miesto ) LIKE '%bratislava%'
OR LOWER( miesto ) LIKE '%malacky%'
OR LOWER( miesto ) LIKE '%pezinok%'
OR LOWER( miesto ) LIKE '%senec%'
ORDER BY nazov
LIMIT 0 , 30

It's supposed to display only records which LOWER(nazov) LIKE something but it still displays everything which contains something from LOWER(miesto). I'm not sure if I explained it correctly. Srry for my english.

Thanks

xdazz · Accepted Answer · 2012-09-24 10:05:58Z

3

You need to wrap the ORs in ().

SELECT id, zadane, firma, nazov, miesto, ukoncenie
FROM praca
WHERE LOWER( nazov ) LIKE '%administratívny pracovník, referent%'
AND potvrdena =1
AND ( 
   LOWER( miesto ) LIKE '%bratislavský kraj%'
   OR LOWER( miesto ) LIKE '%bratislava%'
   OR LOWER( miesto ) LIKE '%malacky%'
   OR LOWER( miesto ) LIKE '%pezinok%'
   OR LOWER( miesto ) LIKE '%senec%' 
)
ORDER BY nazov
LIMIT 0 , 30

answered Sep 24, 2012 at 10:05

xdazz

161k38 gold badges255 silver badges278 bronze badges

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

Comments

rkosegi · Accepted Answer · 2012-09-24 10:07:07Z

0

Try this:

SELECT id, zadane, firma, nazov, miesto, ukoncenie
FROM praca
WHERE LOWER( nazov ) LIKE '%administratívny pracovník, referent%'
AND potvrdena =1
AND( 
   LOWER( miesto ) LIKE '%bratislavský kraj%'
OR LOWER( miesto ) LIKE '%bratislava%'
OR LOWER( miesto ) LIKE '%malacky%'
OR LOWER( miesto ) LIKE '%pezinok%'
OR LOWER( miesto ) LIKE '%senec%'
)
ORDER BY nazov
LIMIT 0 , 30

answered Sep 24, 2012 at 10:07

rkosegi

14.8k5 gold badges57 silver badges90 bronze badges

Collectives™ on Stack Overflow

MySQL query with LIKE

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