例子:
// 删除以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]';
mb61bc2ba16eece 博主文章分类: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]';
上一篇:C语言中strcpy()
下一篇:MYSQL仅仅向某个字段进行插入
java 正则表达式匹配数字去掉前面的字符
举报文章
请选择举报类型
补充说明
0/200
上传截图
格式支持JPEG/PNG/JPG,图片不超过1.9M