select * from transportorders where concat(DepartureFromAddress,ReachToAddress) like '%海关%'; concat函数如有不明请行查看mysql参考手册