REPLACE SELECT column_name, REPLACE(column_name, '현재값', '바꿀값')FROM table_nameWHERE column_name like '%현재값%' 사용예시) food_orders 테이블의 restaurant_name컬럼에서 'Blue Ribbon'이 들어간 상점명을 'Pink Ribbon'으로 바꾸기SELECT restaurant_name "원래 상점명", REPLACE(restaurant_name, 'Blue', 'Pink') "바뀐 상점명"FROM food_ordersWHERE restaurant_name like '%Blue Ribbon%' SUBSTRING(STUBSTR) SELECT column_name SUBSTR(column_name..
