비교 연산자

• A = B : 같다
• A < B : B가 더 크다
• A > B : A가 더 크다
• A <> B, A != B : 같지 않다
• A <= B : B가 A보다 크거나 같다
• A >= B : A가 B보다 크거나 같다

select name, age
    -> from celeb
    -> where age = 30
    -> order by age ;

select name, age
    -> from celeb
    -> where age != 30
    -> order by age ;

 select name, age
    -> from celeb
    -> where age > 30
    -> order by age ;

 select name, age
    -> from celab
    -> where age < 30
    -> order by age DESC;

select name, age, job_title
    -> from celab
    -> where age >= 30
    -> order by age DESC;

 select name, age, job_title
    -> from celab
    -> where age <= 30
    -> order by age ;

select *
    -> from celab
    -> where age <> 30
    -> order by age ;

논리 연산자

and : 둘다 해당
select * from 테이블명 where column 조건 A AND 조건 B

or : 둘중하나 해당
select * from 테이블명 where column 조건 A OR 조건 B

NOT : 아니다
select * from 테이블명 where column NOT 조건 A

Between : 사이 값
select * from 테이블명 where column BETWEEN 조건 A AND 조건 B

IN : 안에 존재하는 지
select * from 테이블명 where column IN (values)

like : 조건 값이 패턴에 맞는지( % : 어떠한 글자 포함, _: 한글자 포함)
select * from 테이블명 where column LIKE pattern