LIKEoperator Syntax:
|
1 2 3 4 |
SELECT [column1, column2, ...] FROM table_name WHERE column_name LIKE pattern; |
Example:
|
1 2 3 4 |
SELECT * FROM cars WHERE model LIKE '%a%'; |
Note: The % wildcard character can be used to match any number of characters (including zero characters).
INoperator Syntax:
|
1 2 3 4 |
SELECT [column1, column2, ...] FROM table_name WHERE column_name IN (value1, value2, ...); |
Example:
|
1 2 3 4 |
SELECT * FROM cars WHERE color IN ('red', 'blue'); |
BETWEENoperator Syntax:
|
1 2 3 4 |
SELECT [column1, column2, ...] FROM table_name WHERE column_name BETWEEN value1 AND value2; |
Example:
|
1 2 3 4 |
SELECT * FROM cars WHERE price BETWEEN 15000 AND 20000; |
=(equal to) operator Syntax:
|
1 2 3 4 |
SELECT [column1, column2, ...] FROM table_name WHERE column_name = value; |
Example:
|
1 2 3 4 |
SELECT * FROM cars WHERE color = 'red'; |
Note: In the examples above, the cars table is assumed to have columns named model, color, and price. The actual syntax may vary depending on the SQL database you are using.