EN
MySQL - UPPER() function example
0 points
In this article, we would like to show you how to use UPPER() function in MySQL.
Quick solutions:
xxxxxxxxxx1
SELECT UPPER('some text...');xxxxxxxxxx1
SELECT UPPER(`column_name`) FROM `table_name`;To show how the UPPER() function works, we will use the following table:
Note:
At the end of this article you can find database preparation SQL queries.
In this example, we will display all the names from users table in uppercase.
Query:
xxxxxxxxxx1
SELECT UPPER(`name`) AS `Uppercase names` FROM `users`;Output:
create_tables.sql file:
xxxxxxxxxx1
CREATE TABLE `users` (2
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,3
`name` VARCHAR(50) NOT NULL,4
`surname` VARCHAR(50) NOT NULL,5
`department_id` INT(10) UNSIGNED,6
`salary` DECIMAL(15,2) NOT NULL,7
PRIMARY KEY (`id`)8
); insert_data.sql file:
xxxxxxxxxx1
INSERT INTO `users`2
( `name`, `surname`, `department_id`, `salary`)3
VALUES4
('John', 'Stewart', 1, '3512.00'),5
('Chris', 'Brown', 2, '1344.00'),6
('Kate', 'Lewis', 3, '6574.00'),7
('Ailisa', 'Gomez', NULL, '6500.00'),8
('Gwendolyn', 'James', 2, '4200.00'),9
('Simon', 'Collins', 4, '3320.00'),10
('Taylor', 'Martin', 2, '1500.00'),11
('Andrew', 'Thompson', NULL, '2100.00');