Question

How to use SQL CHAR_LENGTH() Function in MySQL

Answer 1

SELECT category, CHAR_LENGTH(category) as CategoryLength
FROM all_info

--  category 	CategoryLength 	
--     aaa           3
--     bbbb          4

 

70+ SQL courses for beginners and professionals

Answer 2

SELECT CHAR_LENGTH('Hello') as Length

-- Length 	
--    5

 

70+ SQL courses for beginners and professionals