Re: 作物タブの成分1～5

このトピックの投稿一覧へ

なし Re: 作物タブの成分1～5

msg# 1.3.3.1.1
depth:
4
前の投稿 - 次の投稿 | 親投稿 - 子投稿.1 | 投稿日時 2014.02.15 00:56 | 最終変更
OhYeah!  管理人   投稿数: 983 オンライン
tSeibun を下記のように作成すると、たとえば「メタラキシル及びメタラキシルM」が「メタラキシル」と単純化され、画面がうるさくなくなります。
--/d
begin transaction;
drop table if exists tSeibun;
create temp table tSeibun (ippanmei varchar primary key, seibun varchar);
insert or ignore into tSeibun select distinct seibun1, ifnull(seibun, seibun1) from m_kihon left join seibun on ippanmei = seibun1 where seibun1 is not null;
insert or ignore into tSeibun select distinct seibun2, ifnull(seibun, seibun2) from m_kihon left join seibun on ippanmei = seibun2 where seibun2 is not null;
insert or ignore into tSeibun select distinct seibun3, ifnull(seibun, seibun3) from m_kihon left join seibun on ippanmei = seibun3 where seibun3 is not null;
insert or ignore into tSeibun select distinct seibun4, ifnull(seibun, seibun4) from m_kihon left join seibun on ippanmei = seibun4 where seibun4 is not null;
insert or ignore into tSeibun select distinct seibun5, ifnull(seibun, seibun5) from m_kihon left join seibun on ippanmei = seibun5 where seibun5 is not null;
update tSeibun set seibun = re_replace('及び.*', seibun, '') where seibun like '%及び%';
commit;
投票数:0 平均点:0.00

投稿ツリー

  条件検索へ