select distinct from longtext

[Thiebo Cremers]

Hello,

In my table, I have data stored in a collumn as longtext.

I would like to select each word of the longtext fields, something like :

SELECT DISCTINCT (each word ???) FROM LongTextField WHERE (word begins with lettre a), ORDER BY (alphabetical order) \G;

Returning a very long list of each word separately allowing me to accomplish a second request which would be :

SELECT * FROM mytable WHERE LongTextField LIKE '%wordbeginingwithlettrea%' ;

I hope my question is clear and that someone can help me with this.

Thanks !