模糊条件删除数据表中某个字段

substring 截取字段中的位置

cast看着这个吧 https://www.cnblogs.com/accumulater/p/6149669.html

DELETE FROM `table_name` WHERE ( cast(substring(unique_code, 6, 8) as SIGNED)>=20201201 AND cast(substring(unique_code, 6, 8) as SIGNED)<=20201201 )