SQL在同一字段中搜索多个值 [英] SQL search multiple values in same field

问题描述

我正在构建一个简单的 search 算法，我想用空格破坏字符串，并在其上搜索数据库，如下所示:

I'm building a simple search algorithm and I want to break my string with spaces, and search my database on it, like so:

$search = "Sony TV with FullHD support";  
$search = explode( ' ', $search );

SELECT name FROM Products WHERE name LIKE %$search[1]% AND name LIKE %$search[2]% LIMIT 6

这可能吗?

推荐答案

是的，您可以使用SQL IN运算符搜索多个绝对值:

Yes, you can use SQL IN operator to search multiple absolute values:

SELECT name FROM products WHERE name IN ( 'Value1', 'Value2', ... );

如果要使用LIKE，则需要改用OR:

If you want to use LIKE you will need to use OR instead:

SELECT name FROM products WHERE name LIKE '%Value1' OR name LIKE '%Value2';

使用AND(如您所尝试的)要求所有条件都为真，使用OR要求至少一个条件为真.

Using AND (as you tried) requires ALL conditions to be true, using OR requires at least one to be true.

这篇关于SQL在同一字段中搜索多个值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！