实例:
SELECT * FROM PT_MSTR WHERE PT_PART LIKE '74%-%K-%5%' AND PT_PM_CODE = 'P' AND PT_PART NOT LIKE '74%-%K-%5%-P' AND PT_PART NOT LIKE '74%-%K-%5%-S' AND PT_PART NOT LIKE '74%-%K-%5%-T'
结果:
实例:
SELECT * FROM PT_MSTR WHERE PT_PART LIKE '74%-%K-%5%' AND PT_PM_CODE = 'P' AND PT_PART NOT LIKE '74%-%K-%5%-P' AND PT_PART NOT LIKE '74%-%K-%5%-S' AND PT_PART NOT LIKE '74%-%K-%5%-T'
结果:
转载于:https://www.cnblogs.com/su1643/p/6956832.html