CREATE DATABASE bts_music;
SHOW DATABASES;
USE bts_music;
CREATE TABLE bts_music.butter (
part INT NOT NULL AUTO_INCREMENT,
lyric VARCHAR(1048),
PRIMARY KEY (part)
);
INSERT INTO butter (part, lyric) VALUES (1, 'Smooth like butter');
INSERT INTO butter (part, lyric) VALUES (2, 'Like a criminal undercover');
INSERT INTO butter (part, lyric) VALUES (3, 'Gon'' pop like trouble');
INSERT INTO butter (part, lyric) VALUES (4, 'Breakin'' into your heart like that');
INSERT INTO butter (part, lyric) VALUES (5, 'Cool shade stunner');
SELECT * FROM bts_music.butter;
LOCATE
문자가 여러개라면 가장 먼저 찾은 문자의 위치를 가져온다.
만약 찾는 문자가 없다면 0 반환
쿼리 예시
SELECT part, LOCATE('i', lyric)
FROM bts_music.butter;
SUBSTRING
만약 입력한 숫자가 문자열의 길이보다 크다면 아무것도 가져오지 않음
쿼리 예시
SELECT part, SUBSTRING(lyric, 3)
FROM bts_music.butter;
RIGHT, LEFT
쿼리 예시
SELECT part, RIGHT(lyric, 3), LEFT(lyric, 3)
FROM bts_music.butter;
UPPER, LOWER
예시 쿼리
SELECT part, UPPER(lyric), LOWER(lyric)
FROM bts_music.butter;
LENGTH
예시쿼리
SELECT part, LENGTH(lyric)
FROM bts_music.butter;
CONCAT
예시쿼리
SELECT part, CONCAT(LEFT(lyric, 1), RIGHT(lyric, 1)) AS first_last
FROM bts_music.butter;
REPLACE
예시쿼리
SELECT part, REPLACE(lyric, ‘ ‘, ‘_’)
FROM bts_music.butter;