SQL_querying_8_String_functions.sql

#### This script is for use with the Parks_and_Rec database created with: MySQL-YouTube-Series/Beginner - Parks_and_Rec_Create_db.sql

## String functions


SELECT LENGTH('skyfall');

SELECT frist_name, LENGTH(first_name) AS length
FROM employee_demographics
ORDER BY length;



SELECT UPPER('sky');
SELECT LOWER('SKY');

SELECT frist_name, UPPER(first_name) AS name_upper
FROM employee_demographics
;



SELECT TRIM('    sky     ');
# removes leading and trailing whitespace
SELECT LTRIM('    sky     ');
SELECT RTRIM('    sky     ');





SELECT first_name,
LEFT(first_name,4),
RIGHT(first_name,4),
SUBSTRING(first_name, 3,2),
birth_date,
SUBSTRING(birth_date, 6,2) AS birth_month
FROM employee_demographics
;



SELECT first_name, REPLACE(first_name, 'a', 'z')
FROM employee_demographics




SELECT LOCATE('x','Alexander')

SELECT first_name, LOCATE('An', first_name)
FROM employee_demographics






SELECT first_name, last_name,
CONCAT(first_name, ' ', last_name) AS full_name
FROM employee_demographics