Checking multiple columns for one value

by

You can use the IN predicate, like so:

SELECT * FROM table WHERE 123 IN(col1, col2, col3, col4);

SQL Fiddle Demo

it’s the opposite version of IN.

No it is not, It is the same as using the ORs the way you did in your question.

To clarify this:

The predicate IN or set membership is defined as1:

enter image description here

Where the Value Expression can be either 2:

enter image description here

So it is fine to do it this way, using the value expression 123, which is a literal.

1, 2: Images from: SQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation in SQL

More Related Contents:

  1. Recreating a query using INNER JOIN? [duplicate]
  2. What is better subquery vs literal on IN clause in mysql
  3. SQL query return data from multiple tables
  4. How to do the Recursive SELECT query in MySQL?
  5. quick selection of a random row from a large table in mysql
  6. MySQL SELECT only not null values
  7. Ordering by specific field value first
  8. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  9. Subqueries with EXISTS vs IN – MySQL
  10. mysql select from n last rows
  11. 60 million entries, select entries from a certain month. How to optimize database?
  12. Mysql Improve Search Performance with wildcards (%%)
  13. MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause
  14. MySQL INSERT INTO … VALUES and SELECT
  15. MySQL error 1241: Operand should contain 1 column(s)
  16. How to select one row randomly taking into account a weight?
  17. Whats the fastest way to lookup big tables for points within radius MySQL (latitude longitude)
  18. quick selection of a random row from a large table in mysql
  19. Compare only day and month with date field in mysql
  20. Syntax error when using except in a query
  21. SELECT query return 1 row from each group
  22. MySQL INNER JOIN select only one row from second table
  23. MySQL Select Query – Get only first 10 characters of a value
  24. SQL query to check if a name begins and ends with a vowel
  25. How to SELECT by MAX(date)?
  26. How to find gaps in sequential numbering in mysql?
  27. OUTPUT Clause in MySQL
  28. Sorting by date & time in descending order?
  29. How to select data where a field has a min value in MySQL?
  30. How to convert a varchar column type to date type without losing the dates

Leave a Comment