SQL_BETWEEN ~ AND, IN(), LIKE

SQL

SQL_BETWEEN ~ AND, IN(), LIKE

S_pot 2021. 5. 28. 14:37

SELECT Name, height FROM usertbl WHERE height BETWEEN 180 AND 183; -- BETWEEN...AND

SELECT * FROM userTbl WHERE addr IN('경남', '전남', '경북'); -- IN()

SELECT Name, height FROM userTbl WHERE name LIKE '김%';

SELECT Name, height FROM userTbl WHERE name LIKE '_종신';