mysql count words
snippet in sql

mysql count words

user9046

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