MySQL multiple columns in IN clause

by

To make effective use of the index, you could rewrite the IN predicate

(x0, y0, x1, y1) IN ((4, 3, 5, 6),(9, 3, 2, 1))

Like this: 

(  ( x0 = 4 AND y0 = 3 AND x1 = 5 AND y1 = 6 ) 
OR ( x0 = 9 AND y0 = 3 AND x1 = 2 AND y1 = 1 )
)

More Related Contents:

  1. SQL Print the name of all Employees together with the name of their supervisor
  2. MySQL how to fill missing dates in range?
  3. Left Outer Join doesn’t return all rows from my left table?
  4. How to split the name string in mysql?
  5. MySQL offset infinite rows
  6. Ordering by the order of values in a SQL IN() clause
  7. SQL Selecting from two Tables with inner join and limit [duplicate]
  8. Can a foreign key reference a non-unique index?
  9. MySQL Group by SUM
  10. How to set a maximum execution time for a mysql query?
  11. Get the latest date from grouped MySQL data
  12. SQL keys, MUL vs PRI vs UNI
  13. MySQL – SELECT WHERE field IN (subquery) – Extremely slow why?
  14. How to copy a row and insert in same table with a autoincrement field in MySQL?
  15. MySQL Error 1264: out of range value for column
  16. How to change the default port of mysql from 3306 to 3360
  17. Special Characters in MySQL Table Name
  18. How to move columns in a MySQL table?
  19. Is it possible to reference one column as multiple foreign keys?
  20. Split a string and loop through values in MySQL stored procedure
  21. How to create dummy variable columns for thousands of categories in Google BigQuery?
  22. how to cast the hexadecimal to varchar(datetime)?
  23. MySQL Select Query – Get only first 10 characters of a value
  24. Most efficient way to store IP Address in MySQL [duplicate]
  25. Postgres LEFT JOIN with WHERE condition
  26. mysql select id and name from other table and join query
  27. DELETE FROM `table` AS `alias` … WHERE `alias`.`column` … why syntax error?
  28. What happens when I exhaust a bigint generated key? How to handle it?
  29. MySQL update statement to store ranking positions
  30. is there a length limit to group_concat or another reason why it would not work on a text field

Leave a Comment