How rewrite query in Django ORM?

[Nikolas]

has any way to rewrite in Django ORM?

SELECT * FROM T
WHERE REPLACE(T.field, '-', ' ') = REPLACE(VALUE,'-', ' ')

its possible?
can add this feature or add sample to Docs?

[Simon Charette]

Hello Nikolas,

It should be a matter of using annotate() with Func(F('field'), function='REPLACE')) ​expressions but I don't think we should be documenting every single use of Func.

I suggest you take a look at [how you can get support](https://code.djangoproject.com/wiki/TicketClosingReasons/UseSupportChannels) if the provided documentation isn't enough to help you solve your issue.

[Nikolas]

i try

obs = Goods.objects\
        .annotate(data2=Func(
                    F('data'),
                    Value("'-'"), Value("' '"),
                    function='replace',

                ))\
        .filter(
            Q(data__contains="Andrew") |
            Q(
                data2=Func(
                    F('data'),
                    Value("'-'"), Value("' '"),
                    function='replace',
                ),
            ))

but cant compare to function (not field), this is not documented, can litle help please?
and i think must be more examples in Docs, complex and big examples, very need.

Thanks for great soft!