Menu
Is there a way to select data where any one of multiple conditions occur on the same field?
Example: I would typically write a statement such as:
select * from TABLE where field = 1 or field = 2 or field = 3
Is there a way to instead say something like:
select * from TABLE where field = 1 || 2 || 3
Any help is appreciated.
849
The WHERE clause can be used with SQL statements like INSERT, UPDATE, SELECT, and DELETE to filter records and perform various operations on the data. We looked at how to query data from a database using the SELECT statement in the previous tutorial.
You can specify multiple conditions in a single WHERE clause to, say, retrieve rows based on the values in multiple columns. You can use the AND and OR operators to combine two or more conditions into a compound condition. AND, OR, and a third operator, NOT, are logical operators.
Actually you often need both "WHERE" and "JOIN". "JOIN" is used to retrieve data from two tables - based ON the values of a common column. If you then want to further filter this result, use the WHERE clause. For example, "LEFT JOIN" retrieves ALL rows from the left table, plus the matching rows from the right table.
The OR condition can be used in the SQL UPDATE statement to test for multiple conditions. This example would update all favorite_website values in the customers table to techonthenet.com where the customer_id is 5000 or the last_name is Reynolds or the first_name is Paige.
Sure thing, the simplest way is this:
select foo from bar where baz in (1,2,3)
select * from TABLE where field IN (1,2,3)
You can also conveniently combine this with a subquery that only returns one field:
select * from TABLE where field IN (SELECT boom FROM anotherTable)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
