56,687
社区成员
发帖
与我相关
我的任务
分享
update products set pro_img SUBSTRING_INDEX(pro_mimg,'|',1)
mysql> select * from products;
+-----------------+-------------------------------------------------------------
------------------------+
| pro_img | pro_mimg
|
+-----------------+-------------------------------------------------------------
------------------------+
| 4108mbXO7-L.jpg | 4108mbXO7-L.jpg|41oSD8U1dVL.jpg|31KNYvN7d5L.jpg|41vHjpK5pZL.
jpg|none|none|none|none |
+-----------------+-------------------------------------------------------------
------------------------+
1 row in set (0.00 sec)
mysql> update products
-> set pro_img=SUBSTRING_INDEX(SUBSTRING_INDEX(pro_mimg,'|',2),'|',-1),
-> pro_mimg=right(pro_mimg,length(pro_mimg)-length(SUBSTRING_INDEX(pro_mimg,
'|',1))-1)
-> ;
Query OK, 1 row affected (0.09 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from products;
+-----------------+-------------------------------------------------------------
--------+
| pro_img | pro_mimg
|
+-----------------+-------------------------------------------------------------
--------+
| 41oSD8U1dVL.jpg | 41oSD8U1dVL.jpg|31KNYvN7d5L.jpg|41vHjpK5pZL.jpg|none|none|no
ne|none |
+-----------------+-------------------------------------------------------------
--------+
1 row in set (0.00 sec)
mysql>