--拼接字符串,然后根据预定条件去除 SELECT item_note9,item_note10 FROM xxx item WHERE (item.item_note9||item.item_note10) NOT LIKE 'Gc%'