MySQL Query with specific WHERE rules

Question

Hello Stackers

I'm having another Question, this time about the deprecated MySQL. I'm having the following Query

mysql_query("SELECT * FROM cms_notificaties WHERE username = '". $user['id'] ."' AND userstatus = 'unseen' OR userstatus = 'priority' ")or die(mysql_error());

This will select all notifictions, even when the WHERE username value isn't correct. However, I Want that only the notifications with the right user id will be requested, but, only the ones with the userstatus unseen OR priority. How can I do that? Is that even possible with MySQL?

A Small sidenote, I Know that MySQL is deprecated, but I need to change the whole CMS for that, which I will do later in time.

`MySQL is deprecated`... oh, I haven't knew. Why? :) – Farside Apr 14 '16 at 10:30 — Farside, Apr 14 '16 at 10:30

score 2 · Answer 1 · edited May 23 '17 at 11:59

2

Take a look at this link where it says that OR has lower operator precedence than AND. So you need to use parentheses, something like this:

SELECT * FROM cms_notificaties WHERE username = '". $user['id'] ."' AND ( userstatus = 'unseen' OR userstatus = 'priority' )

edited May 23 '17 at 11:59

Community

1
1

answered Apr 14 '16 at 10:32

eol

23,236
5
46
64

Thanks, I didn't know that, this indeed fixed the problem. Does this work similar in MySQLi? – Pascal Boschma Apr 14 '16 at 11:03

score 1 · Accepted Answer · answered Apr 14 '16 at 10:31

1

Use bracket around OR condition.

SELECT * FROM cms_notificaties WHERE username = '". $user['id'] ."' AND ( userstatus = 'unseen' OR userstatus = 'priority' )

answered Apr 14 '16 at 10:31

Deval Shah

1,094
8
22

MySQL Query with specific WHERE rules

2 Answers2