Skip to content

Instantly share code, notes, and snippets.

@chason

chason/gist:98c7c56f2b850c7088bfd640fbccc563

Created December 6, 2018 02:59
Show Gist options
  • Save chason/98c7c56f2b850c7088bfd640fbccc563 to your computer and use it in GitHub Desktop.
Save chason/98c7c56f2b850c7088bfd640fbccc563 to your computer and use it in GitHub Desktop.
Download ZIP
Django query to ignore 株式会社 prefix when sorting company names
Raw
gistfile1.txt
Company.objects.all().order_by(Func(F('name'), Value('^株式会社'), Value(''), function='REGEXP_REPLACE'))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment