regex 정규식

한글만 찾기
.*[ㄱ-ㅎㅏ-ㅣ가-힣]+.*

mysql 에서 검색시 

select * from test where name regexp '가'

select * from test where name regexp '가|나|다|라'

select * from test where name regexp '[가-힇]


select * from test where name regexp '^[가-힇]+$''

UPDATE tbl_name
SET field_name = REPLACE(field_name,string_to_find,string_to_replace)

WHERE conditions