I have a db app in which one column contains a blob of HTML code. I want to be able to query the text only by filtering the HTML tags first. Obviously, I can make a copy of the whole table using JavaScript to filter the tags, then query the copy. But that solution is too ugly to live. The idea would be to include the same (or eqivalent) REGEXP that works with JavaScript right in the SELECT command. However, as far as I can tell, while SQLite does allow for a REGEXP, it is not implemented by default. Instead it has to be added as a user function, which is prohibited by Gears for security reasons.
First, is my understanding of these facts correct, or have I missed something? And if I am correct, is there a work around that doesn't involve making a copy of the table (or a major portion of it)? If I'm missing something, please clarify and give an example or two I can use to meet my needs. Thanks
