MySQL查询字符串包含 [英] MySQL query String contains

问题描述

我一直在尝试找出如何使用MySQL进行查询，以检查某列中的值(字符串$haystack)是否包含某些数据(字符串$needle)，如下所示:

I've been trying to figure out how I can make a query with MySQL that checks if the value (string $haystack ) in a certain column contains certain data (string $needle), like this:

mysql_query("
SELECT *
FROM `table`
WHERE `column`.contains('{$needle}')
");

在PHP中，该函数称为substr($haystack, $needle)，所以也许:

In PHP, the function is called substr($haystack, $needle), so maybe:

WHERE substr(`column`, '{$needle}')=1

推荐答案

实际上很简单:

mysql_query("
SELECT *
FROM `table`
WHERE `column` LIKE '%{$needle}%'
");

%是任何字符集(无，一个或多个)的通配符.请注意，这在非常大的数据集上可能会变慢，因此，如果数据库增长，则需要使用全文索引.

The % is a wildcard for any characters set (none, one or many). Do note that this can get slow on very large datasets so if your database grows you'll need to use fulltext indices.

这篇关于MySQL查询字符串包含的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！