如何使用LIKE在xml标记之间查找一些信息

问题描述

你好，我现在遇到问题，我不知道是否有可能用SQL进行操作，

我有一个包含联系人的表，为简单起见，示例中有2列ID和XMLdata，而XMLdata列中有xml数据，例如:< some long =""sutff ="> ..... name> ; john< last name ="> doesomething more> ...

如何搜索XMLdata列的名称或姓氏?

因为我无法使用SELECT * FROM Contacts WHERE XMLdata LIKE``< name>％john％''之类的东西，所以我需要像这样的东西

这有可能吗?

谢谢

Hello i am having a problem right now, i don''t know if it is even possible to do in SQL,

i have a table that contains contacts this table for simplicity of example has 2 columns ID and XMLdata in the XMLdata column there is xml data for example: "<some long="" sutff="">.....name>john<last name="">doesomething more>...

how can i search for name or last name of the column for XMLdata?

cause i can''t use something like SELECT * FROM Contacts WHERE XMLdata LIKE ''<name>%john%'', and i need somethjing like that

is this possible to do?

Thanks

推荐答案

这篇关于如何使用LIKE在xml标记之间查找一些信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！