Q:

MYSQL: Pull Only Words with Minimum Character length

how can I pull only words with maximum 50 Characters from MYSQL?
$query = "SELECT * FROM example ORDER BY ID DESC LIMIT 200"; 

A:

Try using the CHAR_LENGTH function in a WHERE constraint:
SELECT * FROM example WHERE CHAR_LENGTH(word) <= 50 ORDER BY ID DESC LIMIT 200

CHAR_LENGTH returns the number of characters in the string. LENGTH returns the number of bytes. It is prefeable to use CHAR_LENGTH if your word could contain multi-byte characters.

