MySQLString FunctionsFORMAT
REVERSE

FORMATString Functions

ASCII

Formats a number as a string with thousands separators.

Syntax

FORMAT(X, D)

Example

Enter values below to update the example in real time.

product_name
price
formatted_price
products
-- 가격을 천 단위 구분 포맷
SELECT product_name, CONCAT('₩', FORMAT(price, 0)) AS formatted_price
FROM products;