MySQL - 如何使用 LIKE 搜索精确的单词匹配? [英] MySQL - How to search for exact word match using LIKE?

问题描述

我正在使用此查询来选择数据:

I'm using this query to select data:

mysql_query("SELECT * FROM products WHERE product_name LIKE '%".$search."%'");

唯一的问题是，它有时会选择比我想要的更多的东西.

The only problem is, that it sometimes selects more, than I would like.

例如，我想选择产品BLA"，但我的查询也选择产品BLABLA".明确地说，如果我想选择产品 1"，我不希望查询选择产品 11".

For example, I would like to select product "BLA", but my query select product "BLABLA" as well. To be clear, if i wanted to select "Product 1", I don't want the query to select "Product 11".

有人知道如何管理吗?

谢谢.

推荐答案

您只想搜索单词边界吗?如果是这样，一个粗略的版本可能是:

Do you just want to search on word boundaries? If so a crude version might be:

SELECT * FROM products WHERE product_name LIKE "% foo %";

或者你可以更聪明一点，用下面的REGEXP

Or you could be a bit cleverer and look for word boundaries with the following REGEXP

SELECT * FROM products WHERE product_name RLIKE "[[:<:]]foo[[:>:]]";

这篇关于MySQL - 如何使用 LIKE 搜索精确的单词匹配?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！