使用截取

substr(列/值,截取开始下标(从0开始,和从1开始都行),截取位数)

SELECT * FROM d504 WHERE years = '2019'  and substr(D504_14,0,4) <> '6205' and substr(area_code,0,4) = '6205'

posted on 2020-03-13 16:13  zaks  阅读(826)  评论(0编辑  收藏  举报