mysql如何利用substring和Locate从string里提取内容

内容reason =  “订单 12345 已发货”； 

select 

SUBSTRING(reason, Locate("订单",reason) +2,Locate("已发货",reason) - Locate("订单",reason)-2) as 订单ID

from Table ;