Hey guys. I'd like to use xquery to extract some data from an xml column. I need to filter the records on the content of some tags in the same manner as the standard LIKE clause. Basically, how would I tansform the following query...
PHP Code:
select unitID, XMLQUERY('for $e in $d/dept/employee return $e/name/text()'
passing d.deptdoc as "d")
from dept d
where unitID LIKE 'WW%' and
XMLEXISTS('$d/dept[@deptID = "V15"]' passing d.deptdoc as "d");
so that the deptID
ends (or starts or contains) with V15? (Example taken from
http://www.ibm.com/developerworks/db...dm-0606nicola/)
Thanks!
dBforums
>
Doing "LIKE" with xquery..?
10-22-08, 10:19
Linear Mode
