Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save wallace57/859dfc5e9eece57bc2b0be5427721b18 to your computer and use it in GitHub Desktop.
Save wallace57/859dfc5e9eece57bc2b0be5427721b18 to your computer and use it in GitHub Desktop.
How to use the SQL replace function in a Django ORM query
from django.db.models import F, Func, Value
from myapp.models import MyModel
# Annotation
MyModel.objects.filter(description__icontains='\r\n').annotate(
fixed_description=Func(
F('description'),
Value('\r\n'), Value('\n'),
function='replace',
)
)
# Bulk replace/fix
MyModel.objects.filter(description__icontains='\r\n').update(
description=Func(
F('description'),
Value('\r\n'), Value('\n'),
function='replace',
)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment