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.