如何提取用|分割的字符串内容 本帖最后由 ACMAIN_CHM 于 2011-01-24 12:57:55 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 mysql> select * from subi;+---------+-------------------------------------------------------------------------------------+| pro_img | pro_mimg |+---------+-------------------------------------------------------------------------------------+| NULL | 4108mbXO7-L.jpg|41oSD8U1dVL.jpg|31KNYvN7d5L.jpg|41vHjpK5pZL.jpg|none|none|none|none |+---------+-------------------------------------------------------------------------------------+1 row in set (0.30 sec)mysql> update subi set pro_img=SUBSTRING_INDEX(pro_mimg,'|',1);Query OK, 1 row affected (0.08 sec)Rows matched: 1 Changed: 1 Warnings: 0mysql> select * from subi;+-----------------+-------------------------------------------------------------------------------------+| 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)楼主上个帖子提过,并且版主也给你回答了; 这次行了,之前板主答的不知道为什么出现问题:#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '( pro_mimg, '|',1 ) WHERE pro_no = 'TG042195'' at line 1怎样也好,很感谢你的解答! 新手求助--通过JDBC向Mysql插入中文数据时,数据库中显示两个问号 帮忙看下这个SQL语句怎么写呢?谢谢 如何将sql2000数据导入到mysql数据库 一个联级操作的问题 Mysql有象Foxpro一样的浏览模式吗? 多个like搜索出每项like的唯一结果 怎么写sql? 高手留步:MySQL和 MaxDB by mysql utf8_general_ci 查询时中文问题 mysql新手关于启动mysql server的问题 MGR+win框架搭建 计算不同分组下,累加时长。 中级难度问题
+---------+---------------------------------------------------------------------
----------------+
| pro_img | pro_mimg
|
+---------+---------------------------------------------------------------------
----------------+
| NULL | 4108mbXO7-L.jpg|41oSD8U1dVL.jpg|31KNYvN7d5L.jpg|41vHjpK5pZL.jpg|none
|none|none|none |
+---------+---------------------------------------------------------------------
----------------+
1 row in set (0.30 sec)mysql> update subi set pro_img=SUBSTRING_INDEX(pro_mimg,'|',1);
Query OK, 1 row affected (0.08 sec)
Rows matched: 1 Changed: 1 Warnings: 0mysql> select * from subi;
+-----------------+-------------------------------------------------------------
------------------------+
| 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)楼主上个帖子提过,并且版主也给你回答了;
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '( pro_mimg,
'|',
1 ) WHERE pro_no = 'TG042195'' at line 1怎样也好,很感谢你的解答!