This content has been marked as final. Show 3 replies
Normalize your database and you won't have problems like this.
> Hi, Can someone plz point me into the wright direction,
> I have a search query that takes comma-delimited list from form and search a
> field with comma delimited list.
> so WHERE 1,3,56,78 = 1,2,3,4,56,53
> How can I accomplish this?
The best place to ask SQL questions might be on an SQL forum, rather than a
ColdFusion one. And answers will vary depending on which DB system you're
using, so it's always a good idea to ask this sort of question on a
I do agree with theother respondents that - given the limited information
you've presented - that it does look like your data model needs some work,
if you're finding yourself needing to do this sort of thing.