[altarek]

i have mysql xml field like this

Code:

<?xml version="1.0" encoding="UTF-8"?>
<record
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 
    xmlns="http://www.loc.gov/MARC21/slim">
 
  <leader>00764nas </leader>
  <controlfield tag="221">011258</controlfield>
 
  <datafield tag="578" ind1=" " ind2=" ">
    <subfield code="a">jaun</subfield>
  </datafield>
  <datafield tag="356" ind1=" " ind2=" ">
    <subfield code="a"></subfield>
    <subfield code="c"></subfield>
  </datafield>
  <datafield tag="333" ind1=" " ind2=" ">
    <subfield code="d">ali</subfield>
    <subfield code="p">22</subfield>
  </datafield>
  <datafield tag="222" ind1=" " ind2=" ">
    <subfield code="c"></subfield>
    <subfield code="d">1984</subfield>
  </datafield>
 
</record>

i don't know how to apply SELECT ExtractValue at this field?

[alxkls]

Code:

select @somevalue, extractvalue(@xml,  '//b[$@somefield]'

[altarek]

I used query like this

Code:

SELECT
  ExtractValue(marcxml,'//datafield[@tag="952"]/*') AS ITEM
FROM marcbib
WHERE bibno=14;

and it give error

FUNCTION employee.ExtractValue does not exist

[alxkls]

first off as far as i can see there is no such tag as 952. second it should be something like

Code:

SELECT @datafield, 
  ExtractValue(@xml ,'//datafield[@tag="952"]/*') AS ITEM
FROM marcbib
WHERE bibno=14;

[altarek]

it give me the same error

[alxkls]

MySQL :: MySQL 5.1 Reference Manual :: 11.11 XML Functions

[altarek]

mysql version not supported this function ?is there another solution?

[alxkls]

update it. the easiest that comes on my mind.