mysql替换中的正则表达式如何保留一部分内容

Question

http://test/main.php?g2_view&g2_itemId=123456，替换成http://ceshi/123456.jpg，原先（一串数字）“123456”在末尾，替换后“123456”在中间，加了后缀，可以实现吗？如何写正则表达式 ？谢谢

Answer 1

是这样吗：
select replace(s,'http://test/main.php?g2_view&g2_itemId=','http://ceshi/')+'.jpg'
from
(
select 'http://test/main.php?g2_view&g2_itemId=123456' s
)tmysql> select replace(s,'http://test/main.php?g2_view&g2_itemId=','http://ceshi/')+'.jpg'
    -> from
    -> (
    -> select 'http://test/main.php?g2_view&g2_itemId=123456' s
    -> )t
    -> ;
+-----------------------------------------------------------------------------+
| replace(s,'http://test/main.php?g2_view&g2_itemId=','http://ceshi/')+'.jpg' |
+-----------------------------------------------------------------------------+
|                                                                           0 |
+-----------------------------------------------------------------------------+
1 row in set, 1 warning (0.13 sec)mysql>