SQL(3)

논리 연산자

AND

mysql> select *
    -> from celab
    -> where
    -> age=29
    -> AND
    -> sex='F';

mysql> select *
    -> from celab
    -> where
    -> sex='M' AND age>40
    -> order by name DESC;
    

OR

mysql> select * from celab where(agency='YG엔터테이먼트' OR agency='나무엑터스') AND age<30;

mysql> select * from celab where (age<29 AND sex='F') OR (age>30 AND sex='M')
    -> order by age AND sex;

NOT

mysql> select*
    -> from celab
    -> where
    -> (agency='YG엔터테이먼트' AND NOT sex='M') OR
    -> (job_title='가수' AND NOT agency='YG엔터테이먼트');
    
mysql> select *
    -> from celab
    -> where
    -> (birthday>19891231 AND NOT sex='F') OR
    -> (birthday<19790101 AND NOT agency='안테나');

BETWEEN

조건값이 범위 사이에 있으면 TRUE

mysql> select * from celab
    -> where
    -> (NOT birthday BETWEEN 19800101 AND 19951231 AND sex='F')
    -> OR (agency='YG엔터테이먼트' AND NOT age BETWEEN 20 AND 45);

IN

목록 안에 조건값이 존재하는 경우 TRUE 

mysql> select* from celab where NOT agency IN('나무엑터스','안테나','울림엔터데이먼트')  AND (sex='F' OR age>=45);

LIKE

조건값이 패턴에 맞으면 TRUE 

mysql> select *
    -> from celab
    -> where agency LIKE 'YG엔터테이먼트';
    
mysql> select*
    -> from celab
    -> where agency LIKE 'YG%';
    
mysql> select*
    -> from celab
    -> where agency Like'%엔터테이먼트';

mysql> select * from celab where agency LIKE '_G%';

mysql> select*from celab where job_title LIKE '가_%';

mysql> select*from celab where job_title LIKE '영%모델';

mysql> select * from celab
    -> where
    -> (job_title LIKE '%,%') AND NOT (job_title LIKE '%영화배우%' OR job_title LIKE '%텔런트%'); ````