Mysql检查列是否包含特定字符串后面的数字

Question

我在mysql数据库中有数百万条记录。我的桌子结构如下：

表名:记录

ID  Records
53468290    Printing Multiple Photos on One Page
53438718    Printing embedded charts on a full page
53442132    Printing and Page Setup Options
53427822    Printing a Web Page                 36
53462121    Printing a Single Address Label (Or a Page of the Same Label)
53470574    Printing a Single Address Label (Or a Page of the Same Label)
53462164    Printing a Single Address Label (Or a Page of the Same Label)
53433527    Printing a Single Address Label (or a Page of the Same Label)
53442687    Printable  CNC Machining, 1st Edition page 99 al
53442686    Printable  CNC Machining, 1st Edition page 98 555
53442685    Printable  CNC Machining, 1st Edition page 97
53442684    Printable  CNC Machining, 1st Edition page 96

我只想删除那些在单词“页面”之后至少有一个数字字符的记录。换句话说，我想删除包含“100页”、“第1页”、“第25 L页”、“第25页5”等的记录。

谢谢

Answer 1

使用REGEXP

DELETE
FROM yourTable
WHERE Records REGEXP '\\b[Pp]age\\s+\\d';

以上为MySQL 8+，早期版本使用：REGEXP '[[:<:]][Pp]age[[:space:]]+[0-9]'