Hi everyone,

I have a freeform string field in one of my tables that is xml encoded.
Basically, i can create xml tags on the fly as and when i want, and just store the entire xml string in the field.

This eliminates the need to create a new column everytime i have a new "datatype". I can just encode with a new xml tag, and add it to the freeform string field.

The problem lies in full text searching.

Since everything is xml encoded, is there anyway to "fulltext" search this xmlencoded string field, but ignore all the xml tags (<item1></item1> <car></car> <book></book> etc)?


Many thanks!

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to