如何提取用|分割的字符串内容 本帖最后由 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怎样也好,很感谢你的解答! mysql服务器端口分配问题 mysql 表名不加单引号不能正常查询,插入,删除,等 博客数据库设计疑问? 求MySQL删除语句 mysql触发器触发后,如何通知程序呢? mysql的10万条记录的表,加索引比不加索引查询速度还慢!!! 为什么last_insert_id的值总是0啊? MySQL,开新用户,限制其权限问题 这句话如何改? mysql没报错误但不出结果 计算不同分组下,累加时长。 中级难度问题
+---------+---------------------------------------------------------------------
----------------+
| 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怎样也好,很感谢你的解答!