Parsing words

------=_NextPart_000_0000_01CC415C.AE16ACA0
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable


Hi Everyone.

Using the following query:


SELECT `topic` FROM `frequently_accessed_passages_of_scripture` WHERE =
`frequently_accessed_passages_of_scripture_theme_reference` =3D 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 =3D "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
=E2=80=9CEncouragement from God=E2=80=99s Word=E2=80=9D
http://www.TheVerseOfTheDay.info

------=_NextPart_000_0000_01CC415C.AE16ACA0--
ron.piggott [ Mi, 13 Juli 2011 18:59 ] [ ID #2062010 ]
PHP » gmane.comp.php.database » Parsing words

Vorheriges Thema: functions, the best way to implement and arrange them..
Nächstes Thema: Duplicate table results