零宽字符

select * from brand_shop_copy1 where 
address like '%‍%' or 
address like '%‌%' or 
address like '%%' or 
address like '%­%' or
address like '% %' or
address like '%​%' or 
address like '%%' or 
address like '% %' or
address like '% %' or
address like '% %' or
address like '% %' or
address like '% %' or
address like '% %'
;

public static void main(String[] args) {
//        System.out.println("select * from brand_shop_copy1 where \n" +
//                "address like '%\u200D%' or\t -- u200D:\u200D" + "\n"+
//                "address like '%\u200C%' or\t -- u200C:\u200C" + "\n"+
//                "address like '%\uFEFF%' or\t -- uFEFF:\uFEFF" + "\n"+
//                "address like '%\u00AD%' or\t -- u00AD:\u00AD" + "\n"+
//                "address like '%\u00A0%' or\t -- u00A0:\u00A0" + "\n"+
//                "address like '%\u200B%' or\t -- u200B:\u200B" + "\n"+
//                "address like '%\uFEFF%' or\t -- uFEFF:\uFEFF" + "\n"+
//                "address like '%\u2000%' or\t -- u2000:\u2000" + "\n"+
//                "address like '%\u2001%' or\t -- u2001:\u2001" + "\n"+
//                "address like '%\u2002%' or\t -- u2002:\u2002" + "\n"+
//                "address like '%\u2003%' or\t -- u2003:\u2003" + "\n"+
//                "address like '%\u2009%' or\t -- u2009:\u2009" + "\n"+
//                "address like '%\u200A%' or\t -- u200A:\u200A" + "\n"+
//                ";");
        System.out.println(Character.isWhitespace('\u200B'));
    }