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

Question

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

Answer 1

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.