问题描述
我有一个 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
这篇关于在 MySQL 中的文本列中搜索字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！