SELECT
IF(LENGTH(pub_time)>100
,SUBSTRING(pub_time,'1','4')
,RIGHT(TRIM(SUBSTRING(pub_time,LOCATE('volume',pub_time)+5,LOCATE('issue',pub_time)-LOCATE('volume',pub_time))),'6')) as pubtime
FROM
journal_refer_data
第一次写成功的复杂sql查询
最新推荐文章于 2019-09-07 07:40:35 发布