[jdom-interest] re: searching for text in XHTML content

Sun Mar 27 09:11:53 PST 2005

--- Ratnakar Pai <pairatnakar at gmail.com> wrote:
> i too had a question of handling Xml columns in
> database.
> Could any of my fellow friends on this site have
> come across such
> scenrio where we store XHTML in column like
> <html><title>My name is
> Tilly</title></html>
> and i have to find out records with ti in the title
> for 1000's of recoreds...
> dont know how to apprach this..
> i dont want to fecth all the records and parse them
> individually and
> get the title and search it...
> also dont want to use data like %ti% cas it will
> fetch me all the
> records since <title> is a string..

Sounds like a typical use case for native xml database
(NXD). There are free open source ones (eXist), and
bunch of good commercial ones too (Jason mentioned one
earlier I think, but there are many others too).

-+ Tatu +-

__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/ 