MySQL搜索忽略连字符

本文介绍了MySQL搜索忽略连字符的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

如何在MySQL中通过"1800flowers"搜索"1-800-flowers"?

How can I search for "1-800-flowers" by "1800flowers" in MySQL?

我有数据"1-800-flowers"，但我想按"1800flowers"找到它.

I have the data "1-800-flowers", but I want to find it by "1800flowers".

推荐答案

最好创建第二列，并用1800flowers填充(替换所有要忽略的字符)并进行搜索.这样，您就可以充分利用索引.

You're probably best off creating a second column that you fill with 1800flowers (replacing all characters you want to ignore) and searching that. That way, you can make full use of indexing.

一种快速转换所有现有数据的方法是

A quick way to convert all existing data would be

UPDATE table SET columnname_without_hyphens = REPLACE(columnname, "-", "");