パラボラ工法協会kaiin_mst2変換sql
UPDATE kaiin_mst2 SET kaiin_companyname=REPLACE(kaiin_companyname, "㈱", "(株)") where kaiin_companyname like '%㈱%'
UPDATE kaiin_mst2 SET kaiin_companyname=REPLACE(kaiin_companyname, "㈲", "(有)") where kaiin_companyname like '%㈲%'