Question

SQL 模糊查询问题 如何用SQl查询 *A*B*C*D* 呢？*为通配符，A,B,C,D代表所包含的字符！

string Filter = ??;
DataView rowfilter = new DataView(ds.Tables[0]);
rowfilter.RowFilter = Filter;
rowfilter.RowStateFilter = DataViewRowState.OriginalRows;
dtInfo = rowfilter.ToTable();
用上面的方法，Filter如何写才能实现查询 *A*B*C*D* 的功能呢？

Answer 1

select * from 表名 where 列名 like '%A%B%C%D%'

或者用select * from 表名where 列名 IN( )

Answer 2

select * from 表名 where 列名 like '%A%B%C%D%'

追问

string Filter = ??;
DataView rowfilter = new DataView(ds.Tables[0]);
rowfilter.RowFilter = Filter;
rowfilter.RowStateFilter = DataViewRowState.OriginalRows;
dtInfo = rowfilter.ToTable();
用上面的C#方法，Filter如何写才能实现查询 *A*B*C*D* 的功能呢？

Answer 3

select * from 表名 where 要查找的列名 like '%A%B%C%D%'

Answer 4

select * from table where column like '%A%B%C%D%'