[TYPO3-dev] Good times with MySQL 5.1
Steffen Kamper
info at sk-typo3.de
Sat Dec 13 11:17:56 CET 2008
Hi,
in future it will be possible to parse XML with MySQL, so the door is
open for parsing templavoila-structure or other flexform structures
direct in SQL [1].
For example extracting the uids of used contentelements of a page it
would be possible to use
SELECT ExtractValue(tx_templavoila_flex, 'sDEF/lDEF/vDEF') as
content_uids from pages
There is also the possibility to Update Records writing single values to
this XML-structure.
vg Steffen
[1] http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html
More information about the TYPO3-dev
mailing list