SELECT * FROM copang_main.member WHERE email = '~~~'; // example
WHERE age (NOT) BETWEEN a AND b; // example
SELECT * FROM copang_main.member WHERE a LIKE '서울%'; // example
SELECT * FROM copang_main.member
WHERE gender != 'm'
AND address LIKE '서울%'; // example
SELECT * FROM copang_main.member
WHERE address LIKE '제주%'
OR address LIKE '서울%'; // example
SELECT * FROM copang_main.member WHERE gender != 'm'; // example
SELECT * FROM copang_main.member WHERE gender <> 'm'; // example
SELECT * FROM copang_main.member WHERE age IN (a, b); // example
SELECT * FROM copang_main.member WHERE email LIKE 'c____@%'; // example
SELECT * FROM copang_main.member WHERE YEAR(birthday) = '1993'; // example
SELECT * FROM copang_main.member WHERE MONTH(birthday) IN (1, 2, 3); // example
SELECT * FROM copang_main.member WHERE DAYOFMONTH(birthday) BETWEEN 10 AND 20; //example
SELECT age, sign_up_day, DATEDIFF(sign_up_day, '2019-10-01') FROM copang_main.member; //example
SELECT age, sign_up_day, DATE_ADD(sign_up_day, INTERVAL 250 DAY) FROM copang_main.member; //example
SELECT age, sign_up_day, DATE_SUB(sign_up_day, INTERVAL 250 DAY) FROM copang_main.member; //example
SELECT age, sign_up_day, UNIX_TIMESTAMP(sign_up_day) FROM copang_main.member; //example
SELECT age, sign_up_day, FROM_UNIXTIME(UNIX_TIMESTAMP(sign_up_day)) FROM copang_main.member; //example
이 외의 날짜, 시간 관련 함수들을 더 알아보기 위해서는 여기를 눌러서 확인해주세요!
LIKE '%\'%' //' (작은 따옴표) 이스케이핑
LIKE '%\_%' // _ (언더바) 이스케이핑
LIKE '%\"%\"%' //" (큰 따옴표) 이스케이핑
LIKE BINARY '%g%';
SELECT * FROM copang_main.member
ORDER BY YEAR(sign_up_day) DESC, email ASC;
SELECT * FROM copang_main.member
ORDER BY sign_up_day DESC
LIMIT 8, 2;
본 포스트는 코드잇 강의를 공부하며 정리한 내용입니다! 자세한 설명은 "코드잇 머신러닝 강의를 참고해주세요!