在 MySQL 中的文本列中搜索字符串

2021-11-20 00:00:00 sql-like search mysql

我有一个 mysql 表，它有一列将 xml 存储为字符串.我需要找到 xml 列包含 6 个字符的给定字符串的所有元组.其他都不重要——我只需要知道这个 6 个字符的字符串是否存在.

I have mysql table that has a column that stores xml as a string. I need to find all tuples where the xml column contains a given string of 6 characters. Nothing else matters--all I need to know is if this 6 character string is there or not.

因此文本格式为 xml 可能无关紧要.

So it probably doesn't matter that the text is formatted as xml.

问题:如何在mysql中搜索?IESELECT * FROM items WHERE items.xml [包含文本'123456']

Question: how can I search within mysql? ie SELECT * FROM items WHERE items.xml [contains the text '123456']

有没有办法使用 LIKE 运算符来执行此操作?

Is there a way I can use the LIKE operator to do this?

推荐答案

您可能可以使用 LIKE 子句做一些简单的字符串匹配:

You could probably use the LIKE clause to do some simple string matching:

SELECT * FROM items WHERE items.xml LIKE '%123456%'

如果您需要更高级的功能，请在此处查看 MySQL 的全文搜索功能:http://dev.mysql.com/doc/refman/5.1/en/fulltext-search.html

If you need more advanced functionality, take a look at MySQL's fulltext-search functions here: http://dev.mysql.com/doc/refman/5.1/en/fulltext-search.html

相关文章