SELECT CHAR_LENGTH(column_name) AS 'alias' FROM table; #example select title, CHAR_LENGTH(title) as 'char_count' from books;