How to add many WHERE constraints when updating a mysql table using php?

Question

How can I add multiple constraints after the WHERE part of the UPDATE MySQL table statement? Is this possible? I have tried separating the constraints using commas. Thank you.

    $update_error = mysqli_query($con, "UPDATE users SET error_level='3'
                    WHERE errors <= '650', errors > '200'");

check this : http://stackoverflow.com/questions/8182896/php-mysql-select-query-with-an-or — Mihir Bhende, May 07 '17 at 18:40

score 2 · Accepted Answer · edited May 07 '17 at 19:08

You should add logical operator (https://dev.mysql.com/doc/refman/5.7/en/logical-operators.html) which will describe to MYSQL what is the connection between conditions:

It will look like this

mysqli_query($con, "UPDATE users SET error_level='3' WHERE errors <= '650' AND errors > '200'");

or this

mysqli_query($con, "UPDATE users SET error_level='3' WHERE errors <= '650' OR errors > '200'");

Craig Bezuidenhout · Answer 2 · 2017-05-07T19:05:28.010

1

SQL :

WHERE errors <= '650'AND errors > '200'

You could also use BETWEEN ( I find this easier to read later )

WHERE errors BETWEEN 200 AND 650

edited May 07 '17 at 19:05

answered May 07 '17 at 18:41

Craig Bezuidenhout

215
1
5

score 0 · Answer 3 · answered May 07 '17 at 18:41

0

UPDATE users SET error_level='3' WHERE errors <= '650' AND errors > '200'

answered May 07 '17 at 18:41

BartBiczBoży

2,512
2
24
33

You might in words point out the difference between a comma and an `AND`... – mkl May 07 '17 at 21:12

How to add many WHERE constraints when updating a mysql table using php?

3 Answers3