求MYSQL 截取字符串语句

Question

啊啊啊||http://localhost:9999/Upload/Images/ask/2011/7/29/129564046197968750.jpg||啊啊啊
截取 "||"到"||" 符号间的字符串

Answer 1

select @a:='啊啊啊||http://localhost:9999/Upload/Images/ask/2011/7/29/129564046197968750.jpg||啊啊啊
'select @b:=reverse(substring(@a,instr(@a,'||')+2));
select reverse(substring(@b,instr(@b,'||')));

Answer 2

select substring_index(substring_index(col,'||,2),'||,-1)

Answer 3

我要的不是这个 http://localhost:9999/Upload/Images/ask/2011/7/29/129564046197968750.jpg
而是 ||外的'啊啊啊' 汉字