SQL And – Or
AND returns the records if both conditions are true.
OR returns the records if at least one of the conditions is true.
And – Or syntax
SELECT * FROM table_name WHERE condition AND condition;
SELECT * FROM table_name WHERE condition OR condition;
SELECT * FROM table_name WHERE condition AND condition OR condition;
And – Or example
Coder books table
ID | Title | Price | Description |
---|
1 | Learn SQL | 20 | Learn SQL language |
2 | Learn MySQL | 22 | Learn MySQL language |
3 | HTML book | 17 | Learn HTML |
4 | Learn PHP | 20 | Introduction to PHP |
5 | Learn PHP | 20 | PHP course |
SELECT * FROM coder_books WHERE price = 20 and id=4;
Result
ID | Title | Price | Description |
---|
4 | Learn PHP | 20 | Introduction to PHP |
SELECT * FROM coder_books WHERE price = 22 or id=3;
Result
ID | Title | Price | Description |
---|
2 | Learn MySQL | 22 | Learn MySQL language |
3 | HTML book | 17 | Learn HTML |