求个简单SQL

Question

create table tb( id int ,xmltype xml)
insert into tb
select 1,'
<m_xml>
<Country>中国</Country>
<Name>王哲</Name>
<Sex>男</Sex>
<EngName>Hank</EngName>
</m_xml>'
union all
select 2,'
<m_xml>
<Country>中国</Country>
<Name>李小龙</Name>
<Sex>男</Sex>
<EngName>Jack.Li</EngName>
</m_xml>'
--查询sex='男' Country,name,sex,engname
select Country,name,sex,engname from tb where ...

Answer 1

select Country,name,sex,engname from tb where charindex('男',xmltype)>0

Answer 2

select id,
   xmltype.value('(/m_xml/Country)[1]','varchar(40)') as Country,
   xmltype.value('(/m_xml/Name)[1]','varchar(40)') as Name,
   xmltype.value('(/m_xml/Sex)[1]','varchar(40)') as Sex,
   xmltype.value('(/m_xml/EngName)[1]','varchar(40)') as EngName
from tb
where xmltype.value('(/m_xml/Sex)[1]','varchar(40)')='男'

Answer 3

XML
在sql中的应用冒搞过啊
UP下

Answer 4

  有<m_xml>表示什么意思啊