在MySQL的LIKE查询中使用OR来比较多个字段 [英] Using OR in LIKE Query in MySQL to compare multiple fields

问题描述

我一直认为您可以在LIKE语句中使用OR来查询MySQL中的内容.因此，如果我想将一行中的多个字段与1个关键字或字词进行比较:

I always thought that you could use OR in a LIKE statment to query things in MySQL. So, if I wanted to compare multiple fields in a row to 1 keyword or term:

SELECT * FROM MyTable WHERE Column1 OR Column2 LIKE '%keyword%'; 

并且如果我有一系列要比较的单词:

and if I had an array of words to compare:

SELECT * FROM MyTable WHERE Column1 OR Column2 LIKE '%keyword1%' 
AND Column1 OR Column2 LIKE '%keyword2%';

但是，我认为语法不正确.除了类似的东西之外，是否有一种有效的方法可以写出这样的文字:

I don't believe that syntax is correct, however. Is there an efficient method of writing this aside from something like:

SELECT * FROM MyTable WHERE Column1 LIKE '%keyword1%' OR Column2 LIKE 
'%keyword1%' AND Column1 LIKE '%keyword2%' OR Column2 LIKE '%keyword2%';

我能正确处理吗?

推荐答案

使用此::

SELECT * FROM MyTable WHERE (Column1 LIKE '%keyword1%' OR Column2 LIKE 
'%keyword1%') AND (Column1 LIKE '%keyword2%' OR Column2 LIKE '%keyword2%');

这篇关于在MySQL的LIKE查询中使用OR来比较多个字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！