mysql query count from a text field code example

Example: mysql count words

SELECT description, LENGTH(TRIM(description)) - LENGTH(REPLACE(TRIM(description), ' ', '')) + 1 FROM test.city