在"where"语句之后的两个值中进行选择

本文介绍了在"where"语句之后的两个值中进行选择的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在尝试在Where语句后编写Select和Where查询以搜索OR值.

I'm trying to write a Select and Where query to search for an OR value after my Where statement.

=query('Jigsaw Stories'!A:O,"select * where K OR L = '" & B5 & "'",-1)

在 K或L 处输入错误.

附加说明:当我这样编写查询时，该查询有效: =query('Jigsaw Stories'!A:O,"select * where K = '" & B5 & "'",-1)

Extra note: The query works when I write it like this: =query('Jigsaw Stories'!A:O,"select * where K = '" & B5 & "'",-1)

推荐答案

=query('Jigsaw Stories'!A:O,"select * where K = '" & B5 & "'" OR L = '" & B5 & "'",-1)