假设有表:
CREATE TABLE `pic_data` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '图片id',
`pic` varchar(255) NOT NULL DEFAULT '' COMMENT '图片url',
`cat` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '图片分类',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
要删除pic里面?以及?后面的内容,sql语句为:
update pic_data set pic = LEFT(pic, INSTR(pic, '?') - 1) where pic like '%?%';