MySQL doesn’t contain built in function for counting number of words in a column. It’s a very common request so we need use a trick for this purpose.
The query bellow returns ...
Here is a useful PHP script for changing collation of your database.
Just follow the steps:
1. Create file e.g.: changedbcollation.php with the following content: