Mysql 数据库 去除某个字段的前10个字符

[zjjhzll]

表名 shop
表结构 ID title titlepic price classid
表内容 1 2013春秋肤色打底裤 /cpimg/aaa.jpg 50.00 1

想批量去除 title字段里的 前10个字符

sql语句该怎么写？

[benluobo]

update shop set title = substring(title,10)

[rucypli]

mysql> select right('123456',length('123456')-1); +------------------------------------+ | right('123456',length('123456')-1) | +------------------------------------+ | 23456 | +------------------------------------+ 1 row in set (0.00 sec)

[test0531]

SELECT replace('123456789123456789',SUBSTR('123456789123456789',1,10),'')

[SQL77]

SET @A='2013春秋肤色打底裤';
SELECT SUBSTRING(@A,10+1) ;
SELECT RIGHT(@A,CHAR_LENGTH(@A)-10);
/*SUBSTRING(@A,10+1)  
--------------------
裤               
RIGHT(@A,CHAR_LENGTH(@A)-10)  
------------------------------
裤                           
*/

[jia_guijun]

mysql> select substring('12345678901234567890',11);

+--------------------------------------+ | substring('12345678901234567890',11) | +--------------------------------------+ | 1234567890 | +--------------------------------------+ 1 row in set (0.00 sec)

[jia_guijun]

update shop set title = substring(title,11);