---
title: "Discussion on \"Optimized SQL Queries for Daily Use !\" | Hashnode"
description: "Discussion on \"Optimized SQL Queries for Daily Use !\". 1. Use ‘regexp_like’ to replace ‘LIKE’ clauses\nNormal Query -\nSELECT *\nFROM\ntable1\nWHERE\nlower(item_name) LIKE '%Table%' OR\nlower(item_name) LIKE '%Chair%' OR\nlower(item_name) LIKE '%Bed%' OR\nlower(item_name) LIKE '%Fan%'\n--and so on\n\nOptimized Query..."
url: "https://hashnode.com/posts/optimized-sql-queries-for-daily-use/64c674e69fc6d39068fe628f"
---

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

Discussion

# [Optimized SQL Queries for Daily Use !](https://theanalystgeek.hashnode.dev/optimized-sql-queries-for-daily-use?utm_source=hashnode&utm_medium=feed)

1\. Use ‘regexp\_like’ to replace ‘LIKE’ clauses Normal Query - SELECT \* FROM table1 WHERE lower(item\_name) LIKE '%Table%' OR lower(item\_name) LIKE '%Chair%' OR lower(item\_name) LIKE '%Bed%' OR lower(item\_name) LIKE '%Fan%' --and so on Optimized Query...

Jul 30, 2023 · 2 min read · theanalystgeek.hashnode.dev  
Read the article

-   [#sql-server](https://hashnode.com/tag/sql-server)
-   [#data-analysis](https://hashnode.com/tag/data-analysis)
-   [#sql](https://hashnode.com/tag/sql)
-   [#sql-server-query-optimization](https://hashnode.com/tag/sql-server-query-optimization)
-   [#sql-optimize](https://hashnode.com/tag/sql-optimize)

## Written by

[The Analyst Geek](https://hashnode.com/@theanalystgeek)

@theanalystgeek · Pune, Maharashtra

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

"Data in Focus, Insights Unveiled"

I am a data enthusiast who finds joy in working with data, utilizing my skills to extract meaningful and valuable insights from it.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
