Non-binary LIKE in MySQL through Django ORM

Question

This is a follow-up from this question. Although I can write a non-binary LIKE query such as - SELECT COUNT(*) FROM TABLE WHERE MID LIKE 'TEXT%' in raw SQL, I would like to know if it's possible through the Django ORM.

Both startswith and contains seem to be using a binary pattern search.

Endre Both · Accepted Answer · 2019-04-16 09:25:08Z

8

Try istartswith and icontains, which in MySQL resolve to LIKE rather than LIKE BINARY.

Note that with MySQL, the case-sensitivity of the comparison depends on the collation set in the database (meaning that i lookups may still be case-sensitive!).

answered Apr 16, 2019 at 9:25

Endre Both

5,8201 gold badge30 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sidharth Samant Over a year ago

You're right. How could I have forgotten about that?

Collectives™ on Stack Overflow

Non-binary LIKE in MySQL through Django ORM

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related