Question

我进行sql 查询 要 [字段A] like "abc" and [字段B] like "fff" or [字段B] like "ggg" 因该怎么写 ？？

我进行sql 查询 要 [字段A] like "abc" and [字段B] like "fff" or [字段B] like "ggg" 因该怎么写 ？？

Answer 1

select * from 表名 where 字段A like '%abc%' and 字段B like '%fff%' or 字段B like 'ggg'

Answer 2

sql="select * from A where [字段A] like '%"abc"%' and ([字段B] like '%"fff"%' or [字段B] like '%"ggg"%')"

Answer 3

sql="select * from [表] where [字段A] like '%"abc"%' and ([字段B] like '%"fff"%' or [字段B] like '%"ggg"%')"