mysql - 使用MYSQL删除字符串中具有一定数量数字的行
问题描述
有没有办法从表中删除字符串中包含一定数量数字的电子邮件地址。例如,g1az11@hotmail.com 可以,因为它有 3 个数字,但 g1az111@hotmail.com 将被删除,因为字符串中有 4 个数字。
我需要在纯 MySql 查询中完成此操作,我无法首先通过 PHP 运行这些查询。
解决方案
推荐阅读
- node.js - How to write custom validation error on mongoose schema?
- java - Spring-Boot UUID: java.sql.SQLException: Invalid utf8 character string
- javascript - RTSP streaming using node js?
- javascript - How to go to next input by pressing enter in soft keyboard in android web-view phonegap build
- android - Layout_alignParentRight and others aren't working
- java - The system cannot find the path specified: Error while starting zookeeper(Apache Kafka)
- mysql - docker下迁移mysql5/laravel 5报错Specified key was too long
- android - Invoke Flutter (Dart) code from native Android home screen widget
- git - git config --list infinte 来袭
- python-3.x - 如何在此代码中创建字典列表?