select * from Table where name like '%X%' and name '%Y%' and name '%Z%' 当字段name 的值为如下值时才可被查到: 待完善.....