Parsing words
| From: | Ron Piggott | Date: | Wed, 13 Jul 2011 16:59:20 +0000 |
| Subject: | Parsing words | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-47922@lists.php.net to get a copy of this message | ||
Hi Everyone.
Using the following query:
SELECT
topic FROM frequently_accessed_passages_of_scripture WHERE
frequently_accessed_passages_of_scripture_theme_reference = 1
I would like to parse all the words out of the column "topic" that are 4 characters long
or more, in alphabetical order, separated by commas, removing all duplicate words. My desired
output is:
$topic = "flower, garden, grass, plant";
Does mySQL have the capacity to do this? (If the query caused the result to be in an alias table so
that is one word per line I could work with this adding the commas) Or do I need to do this within
PHP?
Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info