Hi,
Is it possible to use a MySqlParameter like so:
select * from table where key IN (:list)
and list is a string of codes?
i've tried with 'Code1','Code2','Code3' and also Code1,Code2,Code3 but neither are producing any results.
So is the WHERE IN Clause supported? I've not found it anywhere in the documentation or forums so far?
many thanks
paul
using the WHERE IN Clause
-
- Posts: 2
- Joined: Tue 31 Jul 2007 10:50
-
- Posts: 4
- Joined: Sun 03 Jun 2007 01:57
I think this SQL construct is suitable enough.[email protected] wrote:Okay, so if i wanted to get a list of specific records what is the most effecient way of doing this?
code = 'Code1' OR code = 'Code2' OR code="Code3'....?
Or is there a more suitable SQL construct?