select query with multiple parameters
Posted: Thu Aug 17, 2006 8:32 am
what I want to accomplish:
Rather then running a query that resembles this:
Rather then running such a cumbersome query, is it possible to pass a comma delimited string as follow.
The syntax is giving me some trouble. Any hints help would be appreciated.
Thx.
Rather then running a query that resembles this:
Code: Select all
SELECT * FROM table1 WHERE (id LIKE 1 || id LIKE 2 || id LIKE 3 || id LIKE 4 || id LIKE 5) || (name LIKE a || name LIKE b || name LIKE c || name LIKE d)Code: Select all
SELECT * FROM table1 WHERE id LIKE (1,2,3,4,5) || name LIKE (a,b,c,d)Thx.