Re: return substrings out of a string

2004-06-30 Thread Wesley Furgiuele
Lana: The easiest thing would be if your field always contained the same number of comma-separated strings. Then you could just do something like a SUBSTRING_INDEX() function to break out the field into separate values. But, assuming your field does not always contain the same number of str

return substrings out of a string

2004-06-30 Thread L a n a
Hello, I’m working on a search function using PHP4 and MYSQL4. I’m looking for a function that allow to take a string value (consisted of several substrings separated by coma) out of db field and return each substring one by one. Could you please tell me if there is a function that can do somet