mysql 使用SUBSTRING_INDEX更新某个字段？之后

2022-01-06 本文已影响0人小沙坨

SELECT SUBSTRING_INDEX(download_url, '?', 1) FROM `t_download_information` ;

UPDATE `t_download_information` SET `download_url`= SUBSTRING_INDEX(download_url, '?', 1);