根据表中部分内容截取，更新其他字段

Question

我在备注信息里面备注一下内容例如：车牌号：鲁S201982  单号：TZ20100901001 ...现在我想把备注信息字段里包含TZ开头的而且是截取接下来的11位数字更新到另外一个字段里具体说：============================
id                  beizhu                                     no
1    车牌号：鲁S201982  单号：TZ20100901001                  TZ20100901001
2    车牌号：鲁S2433  单号：TZ20100901002                    TZ20100901002

Answer 1

mysql> update tb set no=substring(beizhu,instr(beizhu,'TZ'),length(beizhu));
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2  Changed: 2  Warnings: 0mysql> select * from tb;
+------+-----------------------------------------------+---------------+
| id   | beizhu                                        | no            |
+------+-----------------------------------------------+---------------+
|    1 | 车牌号：鲁S201982 单号：TZ20100901001         | TZ20100901001 |
|    2 | 车牌号：鲁S2433 单号：TZ20100901002           | TZ20100901002 |
+------+-----------------------------------------------+---------------+
2 rows in set (0.00 sec)

Answer 2

id                       beizhu                                     no
1           车牌号：鲁S201982 单号：TZ20100901001                 null
2           车牌号：鲁S2433 单号：TZ20100901002                   null结果：
=========================================
id                       beizhu                                  no
1                 车牌号：鲁S201982 单号：TZ20100901001      TZ20100901001
2                 车牌号：鲁S2433 单号：TZ20100901002        TZ20100901002

Answer 3

2L错了
update tb set no=substring(beizhu,instr(beizhu,'TZ'),11);

Answer 4

update tb set no=substring(beizhu,instr(beizhu,'TZ'),13);

Answer 5

update tb set no=substring(beizhu,instr(beizhu,'TZ'),11);

Answer 6

如果在最后，还可以这样求。
update tb set no=SUBSTRING_INDEX(beizhu,'单号：TZ',-1);

Answer 7

update tb set no=substring(beizhu,instr(beizhu,'TZ'),(2,13));
想把TZ去掉，而且是查询包含TZ的后11位数字更新到下一个字段里

Answer 8

update tb set no=substring(beizhu,instr(beizhu,'TZ')+2,13);

Answer 9

update tb set no=substring(beizhu,instr(beizhu,'TZ')+2,11);