Any mySQL/SQL experts around?

[Tempest]

Is there an "easy" way to grab all records where the number of spaces (or some other character, or even a strnig) in a specific field is > then a set number? eg: you you want to count the "words" in each sentence that's been stored in a field.

[teksonline]

maybe, might be easier to use php/mysql


using strlen, substr, substr_count etc

[milambur]

Is there an "easy" way to grab all records where the number of spaces (or some other character, or even a strnig) in a specific field is > then a set number? eg: you you want to count the "words" in each sentence that's been stored in a field.

Take a look here:
http://dev.mysql.com/doc/refman/4.1/...functions.html

You should be able to solve it with regular expressions.