Bug #51880 Frq: provide build in xml html tidy function
Submitted: 9 Mar 2010 18:03 Modified: 10 Mar 2010 9:10
Reporter: [ name withheld ] Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: XML functions Severity:S4 (Feature request)
Version:14.14 Distrib 5.1.41 OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[9 Mar 2010 18:03] [ name withheld ]
Description:
hi

in order to this thread: http://forums.mysql.com/read.php?44,357524,357666#msg-357666 i would like to add a feature request. it would be cool if you could add the tidy api from http://tidy.sourceforge.net/ for a build in function.

so someone can do: 
select ExtractValue(TIDY(foo.html), '//tr/td[@class="masterdata_value"]') from foo foo;

would be really cool!

thanks 
christian

How to repeat:
download html homepages and try to parse via "ExtractValue"

Suggested fix:
would be cool if you could add the tidy api from http://tidy.sourceforge.net/ for a build in function.

so someone can do: 
select ExtractValue(TIDY(foo.html), '//tr/td[@class="masterdata_value"]') from foo foo;
[10 Mar 2010 9:10] Valeriy Kravchuk
Thank you for the feature request.