https://blog.51cto.com/u_16213419/12010686

select * from (

    select '1 - 副本 (2).txt' as path
    union
    select '1 - 副本 (5).txt' as path
    union
    select '1 - 副本 (5).txt1111' as path

) where path not in (select path from t_doc)

原文出处：/show_1GW1L1SmKqT7.html