How to pass a variable to a IN clause?

by

Pass parameter value like this – 'AA,BB,CC'. Then, it is enough to use FIND_IN_SET function –

SELECT product_id, product_price
FROM product
WHERE FIND_IN_SET(product_type, param);

More Related Contents:

  1. Create table variable in MySQL
  2. Using variable in a LIMIT clause in MySQL
  3. Stored procedure that Automatically delete rows older than 7 days in MYSQL
  4. Pass array to MySQL stored routine
  5. How can I simulate an array variable in MySQL?
  6. How to raise an error within a MySQL function
  7. MySQL stored procedure vs function, which would I use when?
  8. MySQL stored procedures use them or not to use them
  9. MySQL variable format for a “NOT IN” list of values
  10. Looping Over Result Sets in MySQL
  11. MySQL create stored procedure syntax with delimiter
  12. MySQL : transaction within a stored procedure
  13. Writing optional parameters within stored procedures in MySQL? [duplicate]
  14. Dynamic table names in stored procedure function
  15. mysql stored procedure that calls itself recursively
  16. MySQL triggers cannot update rows in same table the trigger is assigned to. Suggested workaround?
  17. How do you debug MySQL stored procedures?
  18. How can I use transactions in my MySQL stored procedure?
  19. MySQL error #2014 – Commands out of sync; you can’t run this command now
  20. use a variable for table name in mysql sproc
  21. Split a string and loop through values in MySQL stored procedure
  22. My SQL Dynamic query execute and get ouput into a variable in stored procedure
  23. Empty IN clause parameter list in MySQL
  24. How to store Query Result in variable using mysql
  25. What is dynamic SQL?
  26. How to use Table output from stored MYSQL Procedure
  27. How do I write an SP in phpMyAdmin (MySQL)?
  28. Creating MYSQL Procedure in Laravel 4 Migrations
  29. is it possible to call a sql script from a stored procedure in another sql script?
  30. Mysql stored procedure don’t take table name as parameter

Leave a Comment