您如何或两个LIKE语句? [英] How do you OR two LIKE statements?
本文介绍了您如何或两个LIKE语句?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我尝试了以下两个语句:
I have tried the following two statements:
-
SELECT col FROM db.tbl WHERE col (LIKE 'str1' OR LIKE 'str2') AND col2 = num
导致语法错误
对于每个结果, -
SELECT col FROM db.tbl WHERE page LIKE ('str1' OR 'str2') AND col2 = num
会导致截断的错误的双精度值:str1"和截断的错误的双精度值:str2".但是,实际上没有返回任何结果.
SELECT col FROM db.tbl WHERE col (LIKE 'str1' OR LIKE 'str2') AND col2 = num
results in a syntax errorSELECT col FROM db.tbl WHERE page LIKE ('str1' OR 'str2') AND col2 = num
results in "Truncated incorrect DOUBLE value: str1" and "Truncated incorrect DOUBLE value: str2" for what looks like every result. However, no results are actually returned.
我认为这两个语句之一会起作用,但事实并非如此.
I figured one of the two statements would work, but they aren't.
推荐答案
SELECT col FROM db.tbl WHERE (col LIKE 'str1' OR col LIKE 'str2') AND col2 = num
这篇关于您如何或两个LIKE语句?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文