---
title: "Performance of ‘=’ vs ‘like’ in SQL 🤔"
url: https://daily.dev/posts/performance-of-vs-like-in-sql--c7ybnwf9o
source_url: https://code.likeagirl.io/performance-of-vs-like-in-sql-950eb91b69ba
type: article
source: "Code Like A Girl"
published: 2022-02-18T13:58:21.551Z
updated: 2022-02-18T13:58:21.556Z
tags: ["sql"]
reading_time: 1
upvotes: 13
comments: 0
language: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Performance of ‘=’ vs ‘like’ in SQL 🤔

**[Code Like A Girl](https://daily.dev/sources/colkgirl)** · 1 min read · 13 upvotes · 0 comments

## Summary

Performance of “=” (equal operator) vs “like”(wildcard operator) which will give us better performance is a frequently asked question. Let’s consider it as a problem statement and try to solve or find among the both which one is going to give us the more optimized result.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://code.likeagirl.io/performance-of-vs-like-in-sql-950eb91b69ba>

## Similar posts on daily.dev

- [Don’t just attend KubeCon \+ CloudNativeCon, Merge Forward your experience\!](https://daily.dev/posts/don-t-just-attend-kubecon-cloudnativecon-merge-forward-your-experience--l0rpp73x8) · CNCF · 0 upvotes · 0 comments
- [Announcing H2 2026 KCDs](https://daily.dev/posts/announcing-h2-2026-kcds-m96goajm1) · CNCF · 1 upvotes · 0 comments
- [Two months of Open Community Groups](https://daily.dev/posts/two-months-of-open-community-groups-asf52zhbs) · CNCF · 0 upvotes · 0 comments

---

Tags: [#sql](https://daily.dev/tags/sql)

[View this post on daily.dev](https://daily.dev/posts/performance-of-vs-like-in-sql--c7ybnwf9o)