where

select * from TEST_T where ID_C=1;
select * from TEST_T where ID_C>5 order by ID_C;
select * from TEST_T where ID_C>5 order by ID_C limit 0,3;
select * from TEST_T where ADD_C='KYOTO';
select * from TEST_T where ADD_C='KYOTO' and ID_C>=4;
select * from TEST_T where ADD_C='KYOTO' or ADD_C='Kyoto';
select * from TEST_T where not(ADD_C='KYOTO') order by ID_C;
select * from TEST_T where not(ADD_C='KYOTO' or ADD_C='NAGASAKI')order by ID_C;