受託会社のCTOのメモ

チラシの裏

市区町村以下のデータの整形方法

select name, deleted_at
from m_area_4
where name like '%ビル%'


select name, deleted_at
from m_area_4
where name like '%タワー%'


select name, deleted_at
from m_area_4
where name like '%ビルを除く%'

select name, deleted_at
from m_area_4
where name like '%タワーを除く%'



update m_area_4
set deleted_at='2019-11-22 06:18:47'
where name like '%タワー%'


update m_area_4
set deleted_at='2019-11-22 06:18:47'
where name like '%ビル%'