Splitting string within query?

[OhLordy]

Is there any way of splitting an element of a table within the query. What I have is a column it one of my tables contains strings of more than one word. I would like to be able to enter a word and if it's soundex is the same as any one of the words in the strin return that row. Is this possible?
Rob

[laserlight]

I'm not sure what you mean by 'soundex', but perhaps you could use LIKE, e.g.
SELECT * FROM table WHERE column LIKE '%$value%';
or something?

[OhLordy]

soundex() works on the phonetics of the string rather than the actual spelling. However it works on the entire string and I want it to just work word by word. I think I may be able to do it using MySQL's regexp function but my poor little brain's starting to scream trying to figure it all out. 🙁