update good set link=concat(left(link,24),'12345678' ,mid(link,33));
mysql> select concat(left(link,24),'12345678' ,mid(link,33)) -> from ( -> select 'http://aaa.com/a.php?id=88888888&v=28' as link union all -> select 'http://asa.com/s.asp?id=77777777&e=21' union all -> select 'http://agg.com/d.php?id=66666666&n=22' union all -> select 'http://ffg.com/e.php?id=32451111&b=22' -> ) t; +-------------------------------------------------+ | concat(left(link,24),'12345678' ,mid(link,33)) | +-------------------------------------------------+ | http://aaa.com/a.php?id=12345678&v=28 | | http://asa.com/s.asp?id=12345678&e=21 | | http://agg.com/d.php?id=12345678&n=22 | | http://ffg.com/e.php?id=12345678&b=22 | +-------------------------------------------------+ 4 rows in set (0.15 sec)mysql>
-> from (
-> select 'http://aaa.com/a.php?id=88888888&v=28' as link union all
-> select 'http://asa.com/s.asp?id=77777777&e=21' union all
-> select 'http://agg.com/d.php?id=66666666&n=22' union all
-> select 'http://ffg.com/e.php?id=32451111&b=22'
-> ) t;
+-------------------------------------------------+
| concat(left(link,24),'12345678' ,mid(link,33)) |
+-------------------------------------------------+
| http://aaa.com/a.php?id=12345678&v=28 |
| http://asa.com/s.asp?id=12345678&e=21 |
| http://agg.com/d.php?id=12345678&n=22 |
| http://ffg.com/e.php?id=12345678&b=22 |
+-------------------------------------------------+
4 rows in set (0.15 sec)mysql>
http://aaddda.com/aa.php?te=ls&id=12345678&v=28