mysql where clause dosnt work

Question

i have this MySQL query to retrieve some data just for those who have language = 3

  SELECT
  noor_content.id,noor_content.body,noor_content.category,noor_content.introtext,noor_content.title,noor_content.keywords,noor_content.language,path 
  FROM (`noor_content`) 
  join noor_categories 
  on (noor_content.category = noor_categories.id) 
  WHERE `language` = '3' 
  AND noor_content.keywords LIKE '%سمنگان%' 
  or noor_content.keywords LIKE '%جوزجان%' 
  or noor_content.keywords LIKE '%سرپل%'

Problem: the query retrieved those data that have another language but i mentioned language='3'

Screenshot:

enter image description here

use `WHERE language = 3 AND (noor_content.keywords LIKE '%سمنگان%' or noor_content.keywords LIKE '%جوزجان%' or noor_content.keywords LIKE '%سرپل%')` — Tamil Selvan C, Jul 12 '14 at 06:09

score 2 · Answer 1 · answered Jul 12 '14 at 06:09

You have to put bracket for AND and ORcondition to satisfy your condition like below

 WHERE `language` = '3' 
  AND (noor_content.keywords LIKE '%سمنگان%' 
  or noor_content.keywords LIKE '%جوزجان%' 
  or noor_content.keywords LIKE '%سرپل%' );

score 1 · Answer 2 · answered Jul 12 '14 at 06:11

It's because AND has higher precedence than OR, so your WHERE clause is being interpreted as:

WHERE (language = 3 AND noor_content.keywords LIKE '%سمنگان%')
OR noor_content.keywords LIKE '%جوزجان%' 
OR noor_content.keywords LIKE '%سرپل%'

The language test is only combined with the first LIKE, not the others. You need to add parentheses:

WHERE language = 3 
AND (noor_content.keywords LIKE '%سمنگان%'
    OR noor_content.keywords LIKE '%جوزجان%' 
    OR noor_content.keywords LIKE '%سرپل%')

score 0 · Accepted Answer · answered Jul 12 '14 at 06:11

0

put conditions in brackets.

 SELECT noor_content.id,noor_content.body,noor_content.category,noor_content.introtext,noor_content.title,noor_content.keywords,noor_content.language,path 
  FROM (`noor_content`) 
  join noor_categories 
  on (noor_content.category = noor_categories.id) 
  WHERE (`language` = '3' )
  AND ((noor_content.keywords LIKE '%سمنگان%') 
  or (noor_content.keywords LIKE '%جوزجان%') 
  or (noor_content.keywords LIKE '%سرپل%' ));

answered Jul 12 '14 at 06:11

JayKandari

1,228
4
16
33

1

Hey Jai tnx man, after i found my first prob, you did answer my second prob. actually i used for loop and i have if and elseif condition and you did answer my sec prob by double (( after AND. – Bahrami-Reza Jul 12 '14 at 06:32
it is best practice to use brackets for each condition. They can be segregated easily. \ – JayKandari Jul 12 '14 at 06:36

Tamil Selvan C · Answer 4 · 2015-05-12T02:15:10.257

Use bracket for search keywords

SELECT noor_content.id,noor_content.body,noor_content.category,noor_content.introtext,noor_content.title,noor_content.keywords,noor_content.language,path 
  FROM `noor_content` 
  join noor_categories 
  on noor_content.category = noor_categories.id
WHERE language = 3 AND 
(noor_content.keywords LIKE '%سمنگان%' or 
noor_content.keywords LIKE '%جوزجان%' 
or noor_content.keywords LIKE '%سرپل%')

Rakesh Patel · Answer 5 · 2014-07-12T07:33:25.207

0

Because you are using OR operator between conditions so use Brackets() 
like this then try

WHERE `language` = '3' 
AND ( noor_content.keywords LIKE '%سمنگان%' 
OR noor_content.keywords LIKE '%جوزجان%'  
OR noor_content.keywords LIKE '%سرپل%' )

edited Jul 12 '14 at 07:33

answered Jul 12 '14 at 06:27

Rakesh Patel

70
6

mysql where clause dosnt work

5 Answers5