Empty IN clause parameter list in MySQL

by

If I have an application where I’m building the IN list dynamically, and it might end up empty, what I sometimes do is initialize the list with an impossible value and add to that. E.g. if it’s a list of usernames, I’ll start with an empty string, since that’s not a possible username. If it’s an auto_increment ID, I’ll use -1 because the actual values are always positive.

If this isn’t feasible because there are no impossible values, you have to use a conditional to decide whether to include AND column IN ($values) expression in the WHERE clause.

More Related Contents:

  1. MySQL variable format for a “NOT IN” list of values
  2. INSERT INTO SELECT statement with more columns which is not in another table
  3. multiple query same table but in different columns mysql
  4. How can I make SQL case sensitive string comparison on MySQL?
  5. 1052: Column ‘id’ in field list is ambiguous
  6. How to do a batch insert in MySQL
  7. Count the occurrences of DISTINCT values
  8. Why does MySQL allow “group by” queries WITHOUT aggregate functions?
  9. Cumulative sum over a set of rows in mysql
  10. Set NOW() as Default Value for datetime datatype?
  11. Add Auto-Increment ID to existing table?
  12. MySQL SELECT DISTINCT multiple columns
  13. SQL DELETE with JOIN another table for WHERE condition
  14. mysql trigger stored trigger is already used by statement which invoked stored trigger
  15. Error Dropping Database (Can’t rmdir ‘.test\’, errno: 17)
  16. Using group by on two fields and count in SQL
  17. Can MySQL convert a stored UTC time to local timezone?
  18. mysql update query with sub query
  19. What is the difference between the backtick and the square bracket in SQL statements?
  20. MySQL CONCAT returns NULL if any field contain NULL
  21. Integrity constraint violation: 1452 Cannot add or update a child row:
  22. What does SQL Select symbol || mean?
  23. How to format number with “.” as thousands separator and “,” as decimal separator?
  24. Using DISTINCT and COUNT together in a MySQL Query
  25. How to check if field is null or empty in MySQL?
  26. INSERT INTO Table from multiple tables
  27. Execute INSERT if table is empty?
  28. Mysql How do you create a clustered index?
  29. MySQL: Computed Column
  30. How do I extract Month and Year in a MySQL date and compare them?

Leave a Comment