SQL Between
The SQL BETWEEN returns records between two values from a select query.
Between syntax
SELECT * FROM table_name WHERE column_name BETWEEN a_value AND b_value;
Between 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 between 10 and 20;
Result
| ID | Title | Price | Description |
|---|---|---|---|
| 1 | Learn SQL | 20 | Learn SQL language |
| 3 | HTML book | 17 | Learn HTML |
| 4 | Learn PHP | 20 | Introduction to PHP |
| 5 | Learn PHP | 20 | PHP course |