retrieve comma delimited data from a field in using SQL

Posted by Nichols on Stack Overflow See other posts from Stack Overflow or by Nichols
Published on 2010-03-12T19:54:02Z Indexed on 2010/03/12 19:57 UTC
Read the original article Hit count: 354

Filed under:

comma

|

delimited

|

sql

I've created a form in php that collects basic information. I have a list box that allows multiple items selected (ie housing, rent, food, water). If multiple items are selected they are stored in a field called Needs seperated by a comma.

I have created a report ordered by the persons needs. The people who only have one need are sorted correctly, but the people who have multiple are sorted exactly as the string passed to the database (ie. housing, rent, food, water) --> which is not what i want.

Is there a way to seperate the multiple values in this field using SQL to count each need instance/occurance as 1 so that there are no comma delimitations shown in the results?

CLICK FOR EXAMPLE

© Stack Overflow or respective owner

Related posts about comma

Select comma separated result from via comma separated parameter

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Select comma separated result from via comma separated parameter PROCEDURE [dbo].[GetCommaSepStringsByCommaSepNumericIds] (@CommaSepNumericIds varchar(max)) AS BEGIN /* exec GetCommaSepStringsByCommaSepNumericIds '1xx1, 1xx2, 1xx3' */ DECLARE @returnCommaSepIds varchar(max); with… >>> More
oracle replace comma with period and period with comma

as seen on Stack Overflow - Search for 'Stack Overflow'
How to change comma with period and period with comma e.g. 1,50,000.25 to 1.50.000,25 in oracle >>> More
ruby comma operator and step question

as seen on Stack Overflow - Search for 'Stack Overflow'
so, i'm trying to learn ruby by doing some project euler questions, and i've run into a couple things i can't explain, and the comma ?operator? is in the middle of both. i haven't been able to find good documentation for this, maybe i'm just not using the google as I should, but good ruby documentation… >>> More
retrieve comma delimited data from a field in using SQL

as seen on Stack Overflow - Search for 'Stack Overflow'
I've created a form in php that collects basic information. I have a list box that allows multiple items selected (ie housing, rent, food, water). If multiple items are selected they are stored in a field called Needs seperated by a comma. I have created a report ordered by the persons needs… >>> More
Convert a IList<int> collection to a comma seperated list

as seen on Stack Overflow - Search for 'Stack Overflow'
Any elegant ways of converting a IList collection to a string of comman seperated id's? "1,234,2,324,324,2" >>> More

Related posts about delimited

How Do I Convert Pipe Delimited to Comma Delimited with Escaping

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am fairly new to scala and I have the need to convert a string that is pipe delimited to one that is comma delimited, with the values wrapped in quotes and any quotes escaped by "\" in c# i would probably do this like this string st = "\"" + oldStr.Replace("\"", "\\\\\"").Replace("|", "\"… >>> More
How to skip extra lines before the header of a tab delimited delimited file in R

as seen on Stack Overflow - Search for 'Stack Overflow'
The software I am using produces log files with a variable number of lines of summary information followed by lots of tab delimited data. I am trying to write a function that will read the data from these log files into a data frame ignoring the summary information. The summary information never contains… >>> More
retrieve comma delimited data from a field in using SQL

as seen on Stack Overflow - Search for 'Stack Overflow'
I've created a form in php that collects basic information. I have a list box that allows multiple items selected (ie housing, rent, food, water). If multiple items are selected they are stored in a field called Needs seperated by a comma. I have created a report ordered by the persons needs… >>> More
Pyton, print delimited list

as seen on Stack Overflow - Search for 'Stack Overflow'
Consider this Python code for printing a list of comma separated values for element in list: print element + ",", What is the preferred method for printing such that a comma does not appear if element is the final element in the list. ex a = [1, 2, 3] for element in a print str(element)… >>> More
Python, print delimited list

as seen on Stack Overflow - Search for 'Stack Overflow'
Consider this Python code for printing a list of comma separated values for element in list: print element + ",", What is the preferred method for printing such that a comma does not appear if element is the final element in the list. ex a = [1, 2, 3] for element in a print str(element)… >>> More