[한글컬럼값 들어있는 것만 지우기]
|
1 2 |
select * from tbl where field like '%[가-힣]%' delete from tbl where field like '%[가-힣]%' |
[영문컬럼값 들어있는 것만 지우기]
|
1 2 |
select * from tbl where field like '%[A-Za-z]%' delete from tbl where field like '%[A-Za-z]%' |
Leave a Reply
You must be logged in to post a comment.