如何在MySQL或PHPMyAdmin中使用通配符删除条目

This is the table which I've get I want to delete entries which are not having _01.jpg in PHPMyAdmin or MySQL

+----+------+---------------------------+-------+--------------------------------------+
| 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 |
+----+------+---------------------------+-------+--------------------------------------+

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

2条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
donglu9825 2014-09-23 09:08
关注
Do it with sql query. The % sign check the _01.jpg in the last of the path fields string.

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

Take a look on pattern-matching for more details.
本回答被题主选为最佳回答 , 对您是否有帮助呢?

解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

查看更多回答(1条)

报告相同问题？

关注问题

如何在MySQL或PHPMyAdmin中使用通配符删除条目 mysql php
2014-09-23 09:04

回答 2 已采纳 Do it with sql query. The % sign check the _01.jpg in the last of the path fields string. delete
在phpmyadmin中制作重复的条目 mysql php sql
2014-02-20 16:42

回答 1 已采纳 I edited your question to reflect your clarifications shown above. The new question is "how do I c
MySql查询在PHPmyadmin中工作，但不能在codeigniter中工作 mysql php
2018-02-09 07:56

回答 2 已采纳 You need to add sma in table name, it is part of table name. Query: $this->db->select("dat
在mysql下创建用户_在Mysql中创建用户帐户的方法
2021-01-18 23:54

weixin_39639040的博客 1.CREATE USERCREATE USER user [IDENTIFIED BY [PASSWORD] 'password'][, user [IDENTIFIED BY [PASSWORD] 'password']] ...要使用CREATE USER，您必须拥有mysql数据库的全局CREATE USER权限，或拥有INSERT权限。对...
从mysql中选择时间戳的范围在phpmyadmin中工作，但不在codeigniter中 mysql php
2018-04-26 11:28

回答 3 已采纳 Use Null as second and FALSE as third parameter as below: $this->db->where(' vrijeme_poziva
MYSQL查询在PHPMyAdmin中工作，但在网站上不起作用 mysql php
2017-04-08 07:07

回答 2 已采纳 It is because of you are performing 2 operations seperated by semiclon in a single query query sho
使用doctrine创建的数据库，未在phpmyadmin中显示 mysql php
2017-09-04 11:19

回答 1 已采纳 That is because you are using the driver pdo_sqlite. It is creating an SQLite database and not a M
mysql中创建的用户_Mysql中创建用户帐户的方法
2021-03-15 12:38

mckaywrigley的博客转自http://www.eygle.com/digest/2008/01/mysql_create_user.html1.CREATE USERCREATE USER user [IDENTIFIED BY [PASSWORD] 'password'][, user [IDENTIFIED BY [PASSWORD] 'password']] ...CREATE USER用于创建新...
如何使用php在phpmyadmin中插入数组数组 mysql php
2016-04-14 09:53

回答 1 已采纳 Use single insert query for three insert operations like this: <?php $insert = "INSERT INTO `m
如何使用表字段id在phpMyAdmin中为MySQL事件提供外键 mysql php
2015-04-13 12:56

回答 1 已采纳 I think you are asking is not possible but instead of that you can use trigger... which will help
无法在phpMyAdmin中添加图像路径 mysql php
2017-01-07 09:41

回答 1 已采纳 Its good to save files / images in folders and just save their name in database. <input type=
shell mysql 创建用户_Mysql中创建用户帐户的方法
2021-03-07 03:14

IT小公主的博客转自：http://www.eygle.com/digest/2008/01/mysql_create_user.html1.CREATE USERCREATE USER user [IDENTIFIED BY [PASSWORD] 'password'][, user [IDENTIFIED BY [PASSWORD] 'password']] ...CREATE USER用于创建...
MySQL SELECT查询在PHPmyadmin中运行，而不是在PHP中 mysql php sql
2014-05-16 19:21

回答 1 已采纳 You are not fetching anything, your code should be like: $query_get_pairs = "SELECT RIGHT(Pair,LO
查看mysql创建了哪些账号_Mysql中创建用户帐户的方法
2021-02-12 07:04

国家级做梦冠军的博客 1.CREATE USERCREATE USER user [IDENTIFIED BY [PASSWORD] 'password'][, user [IDENTIFIED BY [PASSWORD] 'password']] ...要使用CREATE USER，您必须拥有mysql数据库的全局CREATE USER权限，或拥有INSERT权限。对...
mysql custom user_Mysql中创建用户帐户的方法
2021-01-19 10:40

步衫的博客 1.CREATE USERCREATE USER user [IDENTIFIED BY [PASSWORD] 'password'] [, user [IDENTIFIED BY [PASSWORD] 'password']] ......要使用CREATE USER，您必须拥有mysql数据库的全局CREATE USER权限，或拥有INSERT...
mysql如何创建程序用户_Mysql中创建用户帐户的方法
2021-02-02 07:24

Leo Yung的博客 1.CREATE USERCREATE USER user [IDENTIFIED BY [PASSWORD] 'password'][, user [IDENTIFIED BY [PASSWORD] 'password']] ...要使用CREATE USER，您必须拥有mysql数据库的全局CREATE USER权限，或拥有INSERT权限。对...
mysql 创建用户 flush_Mysql中创建用户帐户的方法
2021-02-01 20:47

weixin_39848998的博客 1.CREATE USERCREATE USER user [IDENTIFIED BY [PASSWORD] 'password'][, user [IDENTIFIED BY [PASSWORD] 'password']] ...要使用CREATE USER，您必须拥有mysql数据库的全局CREATE USER权限，或拥有INSERT权限。对...
mysql 赋权限语句详细_Mysql中建账号和赋权限的方法
2021-01-21 14:29

顾培的博客 1.CREATE USERCREATE USER user [IDENTIFIED BY [PASSWORD] 'password'][, user [IDENTIFIED BY [PASSWORD] 'password']] ...要使用CREATE USER，您必须拥有mysql数据库的全局CREATE USER权限，或拥有INSERT权限。对...
没有解决我的问题, 去提问

悬赏问题

¥15 FPGA-SRIO初始化失败
¥15 MapReduce实现倒排索引失败
¥15 ZABBIX6.0L连接数据库报错，如何解决？(操作系统-centos)
¥15 找一位技术过硬的游戏pj程序员
¥15 matlab生成电测深三层曲线模型代码
¥50 随机森林与房贷信用风险模型
¥50 buildozer打包kivy app失败
¥30 在vs2022里运行python代码
¥15 不同尺寸货物如何寻找合适的包装箱型谱
¥15 求解 yolo算法问题

如何在MySQL或PHPMyAdmin中使用通配符删除条目

2条回答 默认 最新

悬赏问题

2条回答默认最新