EN
MySQL - convert value to CHAR (using CONVERT() function)
0
points
In this article, we would like to show you how to convert a value to CHAR type using CONVERT() function in MySQL.
Quick solution:
SELECT CONVERT(value, CHAR);
Simple example
In this example, we will convert INT value to CHAR type.
Query:
SELECT CONVERT(100, CHAR) AS 'int_to_char';
Result:
Practical example
To show how to convert value to CHAR, we will use the following values table:
Note:
At the end of this article you can find database preparation SQL queries.
Example
In this example, we will convert max_value column (which is INT type) from values table to CHAR type.
Query:
SELECT
`id`, `min_value`, `max_value`,
CONVERT(`max_value`, CHAR) AS 'max_value_char'
FROM `values`;
Output:
Database preparation
create_tables.sql file:
CREATE TABLE `values` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`min_value` INT,
`max_value` INT,
PRIMARY KEY (`id`)
);
insert_data.sql file:
INSERT INTO `values`
(`min_value`, `max_value`)
values
(1000, 1500),
(1500, 2000),
(1400, 2500),
(1200, 3000),
(1800, 3500);