excel身份证前两位提取省份

页面:/news/view-1084746/ | 耗时:0.2912 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=1084746 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1084746 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1084746 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(829313,406887,1126386,711301,672500,92855,590465,1554075,606548,767988,1116003,475782,1085663,423137,616558,481416,105057,2695711,849027,486880,81992,563738,856329,954838,599865,409609,886519,443747,591172,1127285) ORDER BY field (ArticleID,829313,406887,1126386,711301,672500,92855,590465,1554075,606548,767988,1116003,475782,1085663,423137,616558,481416,105057,2695711,849027,486880,81992,563738,856329,954838,599865,409609,886519,443747,591172,1127285)