Re: data with dynamic schema stored in a column as a property list.

Hello, I think you can use a fulltext index and a regex: select * from table where match( ftfield) against ('+interests +reading' in boolean mode) and ftfield rlike your regexp or select * from table where match( ftfield) against ('+interests +reading' in boolean mode) having ftfield rlike

Re: data with dynamic schema stored in a column as a property list.

Have you considered a combination of Full-text indexing (to quickly locate a subset of records that may match your criteria) and regular expression matching (to eliminate the non-matching results from the results of the full-text search)? I know it's two steps but your data is practically

Re: data with dynamic schema stored in a column as a property list.

Thanks Shawn. I guess your suggestion maybe the only thing I can do about it. But the problem itself has an interesting background: I developed an web application handling dynamic online conference registrations; including a table BusinessSeason to hold the information about the registration

Re: data with dynamic schema stored in a column as a property list.

Thanks for the history. It's always good to learn how these things come into existence. There are some storage schemes for hierarchical information that you may be able to apply to your needs. Here is a good tutorial various methods: http://www.sitepoint.com/article/hierarchical-data-database

data with dynamic schema stored in a column as a property list.

Hi, instead of xml, i stored arbitrary data of the form (the actual usage of such mechanism is for more fancy stuff, say, dynamic configuration, otherwise this is really not necessary) { name = Fn, Ln; // string value gender = F;

data with dynamic schema stored in a column as a property list.

Hi, instead of xml, i stored arbitrary data of the form (the actual usage of such mechanism is for more fancy stuff, say, dynamic configuration, otherwise this is really not necessary) { name = Fn, Ln; // string value gender = F;