id summary reporter owner description type status priority milestone component version severity resolution keywords cc branch changelog apichanges internalchanges 3273 Add REGEXP support to SQL queries david.l.jones@… "SQLite allows the use of a REGEXP search ![1]. Such a feature would be useful in cases such as parsing multiple CCs, multiple asignees on a ticket ![2], etc. All that has to be done is to create a user function on the connection ![3]. I've attached a diff of what (I think) will enable this (I am using r3406 currently). The patch will add a user function in SQLite immediately after the connection is made. The user function is called regexp. (See [attachment:trac_sqlite_regexp_r3406.patch]) References: 1. [http://www.sqlite.org/lang_expr.html]: What is currently allowed in SQLite expressions 2. #2662: Using REGEXP in SQLite to parse multi-user assignments 3. [http://initd.org/pub/software/pysqlite/doc/usage-guide.html#creating-user-defined-functions] pysqlite documentation to add a user-defined function" enhancement new normal next-major-releases report system devel minor sqlite regexp patch mmitar@…