Changing charater set in mysql

If we have stored the values in the tables in other languages than english then while selecting use this mysql query to convert the charset
"SET CHARACTER SET 'utf8'"