.dev/useful/__SQL/update_interests.sql from yfix/yf

.dev/useful/__SQL/update_interests.sql
Summary

Maintainability

Test Coverage

Issues
INSERT INTO t_interests_keywords (`keyword`) SELECT LOWER(SUBSTRING_INDEX(SUBSTRING_INDEX(`keywords`,';',2),';',-1)) AS `0` FROM `t_interests` WHERE `keywords` NOT IN('', ';;') ON DUPLICATE KEY UPDATE `users` = `users` + 1
INSERT INTO t_interests_keywords (`keyword`) SELECT LOWER(SUBSTRING_INDEX(SUBSTRING_INDEX(`keywords`,';',3),';',-1)) AS `0` FROM `t_interests` WHERE `keywords` NOT IN('', ';;') ON DUPLICATE KEY UPDATE `users` = `users` + 1
INSERT INTO t_interests_keywords (`keyword`) SELECT LOWER(SUBSTRING_INDEX(SUBSTRING_INDEX(`keywords`,';',4),';',-1)) AS `0` FROM `t_interests` WHERE `keywords` NOT IN('', ';;') ON DUPLICATE KEY UPDATE `users` = `users` + 1
INSERT INTO t_interests_keywords (`keyword`) SELECT LOWER(SUBSTRING_INDEX(SUBSTRING_INDEX(`keywords`,';',5),';',-1)) AS `0` FROM `t_interests` WHERE `keywords` NOT IN('', ';;') ON DUPLICATE KEY UPDATE `users` = `users` + 1
INSERT INTO t_interests_keywords (`keyword`) SELECT LOWER(SUBSTRING_INDEX(SUBSTRING_INDEX(`keywords`,';',6),';',-1)) AS `0` FROM `t_interests` WHERE `keywords` NOT IN('', ';;') ON DUPLICATE KEY UPDATE `users` = `users` + 1
INSERT INTO t_interests_keywords (`keyword`) SELECT LOWER(SUBSTRING_INDEX(SUBSTRING_INDEX(`keywords`,';',7),';',-1)) AS `0` FROM `t_interests` WHERE `keywords` NOT IN('', ';;') ON DUPLICATE KEY UPDATE `users` = `users` + 1
INSERT INTO t_interests_keywords (`keyword`) SELECT LOWER(SUBSTRING_INDEX(SUBSTRING_INDEX(`keywords`,';',8),';',-1)) AS `0` FROM `t_interests` WHERE `keywords` NOT IN('', ';;') ON DUPLICATE KEY UPDATE `users` = `users` + 1
INSERT INTO t_interests_keywords (`keyword`) SELECT LOWER(SUBSTRING_INDEX(SUBSTRING_INDEX(`keywords`,';',9),';',-1)) AS `0` FROM `t_interests` WHERE `keywords` NOT IN('', ';;') ON DUPLICATE KEY UPDATE `users` = `users` + 1
INSERT INTO t_interests_keywords (`keyword`) SELECT LOWER(SUBSTRING_INDEX(SUBSTRING_INDEX(`keywords`,';',10),';',-1)) AS `0` FROM `t_interests` WHERE `keywords` NOT IN('', ';;') ON DUPLICATE KEY UPDATE `users` = `users` + 1
INSERT INTO t_interests_keywords (`keyword`) SELECT LOWER(SUBSTRING_INDEX(SUBSTRING_INDEX(`keywords`,';',11),';',-1)) AS `0` FROM `t_interests` WHERE `keywords` NOT IN('', ';;') ON DUPLICATE KEY UPDATE `users` = `users` + 1