SQLでピリオドで終わってないアイテムにピリオドをつける

-- Add period
UPDATE `mytable` SET `word`= CONCAT(word, '.') WHERE `word` NOT LIKE '%.';

1 2	-- Add period UPDATE `mytable` SET `word`= CONCAT(word, '.') WHERE `word` NOT LIKE '%.';

-- Trim All
UPDATE `mytable` SET `word`= TRIM(word);

1 2	-- Trim All UPDATE `mytable` SET `word`= TRIM(word);

-- remove ...
UPDATE `mytable` SET `word`= REPLACE(word, '...', '') ;

1 2	-- remove ... UPDATE `mytable` SET `word`= REPLACE(word, '...', '') ;

-- Add period after trim
UPDATE `mytable` SET `word`= CONCAT(LTRIM(RTRIM(word)), '.') WHERE `word` NOT LIKE '%.';

1 2	-- Add period after trim UPDATE `mytable` SET `word`= CONCAT(LTRIM(RTRIM(word)), '.') WHERE `word` NOT LIKE '%.';

-- replace "?." with "."
UPDATE `mytable` SET `word`= REPLACE(word, '?.', '.') WHERE `word` RLIKE '\\?\\.$';

1 2	-- replace "?." with "." UPDATE `mytable` SET `word`= REPLACE(word, '?.', '.') WHERE `word` RLIKE '\\?\\.$';

-- replace ". ." to "."
UPDATE `mytable` SET `word`= REPLACE(word, '. .', '.') WHERE `word` LIKE '%.';

1 2	-- replace ". ." to "." UPDATE `mytable` SET `word`= REPLACE(word, '. .', '.') WHERE `word` LIKE '%.';