MySQLString FunctionsCHAR_LENGTH
LENGTH

CHAR_LENGTHString Functions

UPPER

Returns the character count of a string.

Syntax

CHAR_LENGTH(str)

Example

Enter values below to update the example in real time.

product_name
description
char_count
products
-- 설명문이 100자 초과하는 상품 조회
SELECT product_name, CHAR_LENGTH(description) AS char_count
FROM products
WHERE CHAR_LENGTH(description) > 100;