id,summary,reporter,owner,description,type,status,component,version,severity,resolution,keywords,cc,stage,has_patch,needs_docs,needs_tests,needs_better_patch,easy,ui_ux 26100,Queryset.extra use case: iregex against regular expressions stored as fields,Jeff Johnson,nobody,"As requested, here is an example of something I couldn't figure out how to do without using Queryset.extra(). Given an email address, find all regular expressions from the database that match the email address. It would be like doing iregex in reverse. {{{ class EmailFilter(models.Model): regex = models.CharField(blank=False, max_length=128, db_index=True, help_text=""Do not send to email addresses that match this regular expression. Not case sensitive. E.g.: ^admin@.*$"") @classmethod def find_matching_rules(cls, email): return cls.objects.extra(where=['%s ~* regex'], params=[email]) }}} ",Uncategorized,closed,"Database layer (models, ORM)",1.9,Normal,worksforme,Queryset.extra,,Unreviewed,0,0,0,0,0,0