mysql 二进制字段拆分转换

select shipid, utc, conv(CONCAT(mid(cast(hex(data) as char),7, 2), mid(cast(hex(data) as char),5, 2), mid(cast(hex(data) as char),3, 2), mid(cast(hex(data) as char),1, 2)),16,10) as lon, conv(CONCAT(mid(cast(hex(data) as char),15, 2), mid(cast(hex(data) as char),13, 2), mid(cast(hex(data) as char),11, 2), mid(cast(hex(data) as char),9, 2)),16,10) as lat, conv(CONCAT(mid(cast(hex(data) as char),19, 2), mid(cast(hex(data) as char),17, 2)),16,10) as sog, conv(CONCAT(mid(cast(hex(data) as char),23, 2), mid(cast(hex(data) as char),21, 2)),16,10) as cog, conv(CONCAT(mid(cast(hex(data) as char),27, 2), mid(cast(hex(data) as char),25, 2)),16,10) as hdg, conv(CONCAT(mid(cast(hex(data) as char),31, 2), mid(cast(hex(data) as char),29, 2)),16,10) as rot, conv( mid(cast(hex(data) as char),33, 2),16,10) as navstat from m_pos