Question

SQL模糊查询语句

我想在表TstorageMenu中，对输入的任意字符跟dishID或dishName进行匹配，可不可以写成这样啊？select dishID as 项目编号,dishName as 菜名,sellprice as 单价,MountNow as 库存量 from TstorageMenu where dishID like % or dishName like %,我用查询分析器运行提示or附近有语法错误，但是我不知道怎样表达，有知道的高手可以告诉我吗？谢谢啦！

Answer 1

同楼上
select dishID as 项目编号,dishName as 菜名,sellprice as 单价,MountNow as 库存量 from TstorageMenu where dishID like '%输入字符%' or dishName like '%输入字符%'

Answer 2

select dishID as 项目编号,dishName as 菜名,sellprice as 单价,MountNow as 库存量 from TstorageMenu where dishID like '%关键字%' or dishName like '%关键字%'

Answer 3

数据库模糊查询