본문으로 바로가기

--int형도 문자로 검색해야 한다



select * from kh_member


select * from kh_member where uaddr1 like '서%'


select * from kh_member where uname like '___4'


select * from kh_member where seq like '[1-5]'


select * from kh_member where uemail like '[k-m]%'


select * from kh_member where uemail like 'a[^b-z]%'


select * from kh_member where uname like '_h%'