---
title: "Discussion on \"`LIKE` uses a range index\" | Hashnode"
description: "Discussion on \"`LIKE` uses a range index\". A Django's Auth table's indexes:\nmysql> show index from auth_user;\n\n+-----------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+\n\n| Table     | Non_un..."
url: "https://hashnode.com/posts/like-uses-a-range-index/664c0077bc7a38c415f6158f"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [\`LIKE\` uses a range index](https://blog.danwald.me/like-uses-a-range-index?utm_source=hashnode&utm_medium=feed)

A Django's Auth table's indexes: mysql> show index from auth\_user; +-----------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non\_un...

May 21, 2024 · 3 min read · blog.danwald.me  
Read the article

-   [#sql](https://hashnode.com/tag/sql)
-   [#index](https://hashnode.com/tag/index)
-   [#django](https://hashnode.com/tag/django)
-   [#mysql](https://hashnode.com/tag/mysql)
-   [#query-optimization](https://hashnode.com/tag/query-optimization)

## Written by

[Danny Crasto](https://hashnode.com/@danwald)

@danwald · dubai, uae

  
[View profile](https://hashnode.com/@danwald)

backend/cloud engineer | mentor | pythonista

I am developer/code-reviewer/debugger/bug-fixer/architect/teacher/builder from dubai, uae

## Responses

Markdown supported · ⌘↵ to post

No responses yet.