MYSQL删除以数字开头的字段

例子：

// 删除以0开头的字段
DELETE FROM `week_energy_copy` WHERE openid like '0%';

// 删除以数字开头的字段
DELETE FROM `week_energy_copy` WHERE openid NOT REGEXP '^[0-9]';

// 删除以大写字母开头的字段
DELETE FROM `week_energy_copy` WHERE openid REGEXP '^[A-Z]';

 

转载于:https://www.cnblogs.com/Robotke1/p/3192799.html