select mainten, SUBSTRING_INDEX(mainten,',',1) +0 AS maintains
from FAS WHERE
e_id <> ''
order by maintainsorder desc
SUBSTRING_INDEX用法,分割字段值
最新推荐文章于 2024-07-18 16:25:47 发布
select mainten, SUBSTRING_INDEX(mainten,',',1) +0 AS maintains
from FAS WHERE
e_id <> ''
order by maintainsorder desc