mysql正則の使用および正則の使用

検索

SELECT title FROM ims_shimmer_liveshop_goods_library WHERE title REGEXP "[^[0-9]]*[0-9]{4}g$"

変更

UPDATE ims_shimmer_liveshop_goods_library SET title = REPLACE(title,SUBSTR(title, -5, 5),"") WHERE title REGEXP "[^[0-9]]*[0-9]{4}g$"

title REGEXP "[^[0-9]]*[0-9]{4}g$"              g