Logical Operations in SQL Query in PHP

In the selection condition, more complex combinations can be made using the commands OR and AND. They work the same way as their analogs in the PHP if construct. Let's look at some examples.

Example

Let's select users with a salary of 500 AND an age of 23 years:

<?php
	$query = "SELECT * FROM users WHERE salary=500 AND age=23";
?>

Example

Let's select users with a salary of 500 OR an age of 23 years:

<?php
	$query = "SELECT * FROM users WHERE salary=500 OR age=23";
?>

Example

Let's select users with a salary from 450 to 900:

<?php
	$query = "SELECT * FROM users WHERE salary>450 AND salary<900";
?>

Example

Let's select users with an age from 23 to 27 years inclusive:

<?php
	$query = "SELECT * FROM users WHERE age>=23 AND age<=27";
?>

Example

Complex combinations of OR and AND commands can be grouped using parentheses to show the priority of conditions:

<?php
	$query = "SELECT * FROM users WHERE (age<20 AND age>27) OR (salary>300 AND salary<500)";
?>

Practical Tasks

Select users aged from 25 (exclusive) to 28 years (inclusive).

Select user user1.

Select users user1 and user2.

Select everyone except user user3.

Select all users aged 27 years or with a salary of 1000.

Select all users aged 27 years or with a salary not equal to 400.

Select all users aged from 23 years (inclusive) to 27 years (exclusive) or with a salary of 1000.

Select all users aged from 23 years to 27 years or with a salary from 400 to 1000.