如何在MySQL或PHPMyAdmin中使用通配符删除条目 - How to delete entries using wildcard in MySQL or PHPMyAdmin

How to delete entries using wildcard in MySQL or PHPMyAdmin

本文关键字：通配符删除 MySQL PHPMyAdmin | 更新日期: 2023-09-27

这是我得到的表，我想删除PHPMyAdmin或MySQL 中没有_01.jpg的条目

+----+------+---------------------------+-------+--------------------------------------+
| id | nid  |           path            | style |           image_name_path            |
+----+------+---------------------------+-------+--------------------------------------+
|  1 | 1002 | 1234567 U14RNMT02_01.jpg  |   123 | 1234567-U14RNMT02-SM14B6_01-245.jpg  |
|  2 | 1003 | 1234567 U14RNMT02_02.jpg  |   123 | 1234567-U14RNMT02-SM14B6_02-245.jpg  |
|  3 | 1004 | 1234567 U14RNMT02_03.jpg  |   123 | 1234567-U14RNMT02-SM14B6_03-245.jpg  |
|  4 | 1005 | 1234567 U14DRYMT07_01.jpg |   123 | 1234567-U14DRYMT07-SM14B6_01-245.jpg |
|  5 | 1006 | 1234567 U14DRYMT07_02.jpg |   123 | 1234567-U14DRYMT07-SM14B6_02-245.jpg |
|  6 | 1007 | 1234567 U14DRYMT07_03.jpg |   123 | 1234567-U14DRYMT07-SM14B6_03-245.jpg |
+----+------+---------------------------+-------+--------------------------------------+

使用sql查询。%符号检查path字段字符串最后一个字段中的_01.jpg。

delete from table_name where path not like '%_01.jpg'

查看图案匹配以了解更多细节。

类似于：

DELETE FROM table_name WHERE column_name NOT LIKE '%_01.jpg'

希望这会奏效。

问候