I have a database with a text field and I'd like to do some kind of
select statement to show me the words that are only used once or
twice.

Is there a way to display words based on the number of times they
appear in a text field?

Thanks

On Nov 7, 4:43 pm, btcar...@lisnews.com wrote:
> I have a database with a text field and I'd like to do some kind of
> select statement to show me the words that are only used once or
> twice.
>
> Is there a way to display words based on the number of times they
> appear in a text field?
>
> Thanks

Either:
1. Pick it up from php/python/asp etc. and then process the text
2. don't keep them all in one field - put all words in separate
records

I really can't think of method to do it your way, but I'm sure it
wouldn't be a
nice thing to let it stay that way.

Regards