BestHub
Sign in
Tagged articles
8 articles
Page 1 of 1
Top Architecture Tech Stack
Top Architecture Tech Stack
May 10, 2025 · Databases

MySQL Query Optimization Guidelines and Best Practices

This article presents a comprehensive set of MySQL optimization techniques, covering the avoidance of SELECT *, proper use of specific fields, index-friendly query patterns, join strategies, handling of NULL and default values, efficient use of UNION, batch inserts, and numerous other performance‑enhancing tips for database developers.

Database TuningSQL Optimizationindexes
0 likes · 17 min read
MySQL Query Optimization Guidelines and Best Practices
dbaplus Community
dbaplus Community
Nov 29, 2022 · Databases

Why MySQL LIKE Pagination Misses Exact Matches and How to Fix It

Combining MySQL LIKE fuzzy search with pagination can push exact‑match rows to later pages, causing duplicate brand entries; this article explains the root cause, demonstrates failing queries, and presents several fixes—including adjusting page size, splitting exact and fuzzy queries, and using CHAR_LENGTH and LOCATE functions for custom ordering.

char_lengthfuzzy-searchlike
0 likes · 9 min read
Why MySQL LIKE Pagination Misses Exact Matches and How to Fix It
Laravel Tech Community
Laravel Tech Community
Sep 7, 2021 · Databases

Handling Backslashes in MySQL INSERT and SELECT Statements

This article explains how MySQL treats backslashes as escape characters in INSERT and SELECT queries, demonstrates the effect of different numbers of backslashes through practical tests, and clarifies the double‑escaping required when using LIKE patterns.

ESCAPEInsertbackslash
0 likes · 6 min read
Handling Backslashes in MySQL INSERT and SELECT Statements
Programmer DD
Programmer DD
Jun 22, 2021 · Databases

Mastering Backslash Escapes in MySQL: Insert & SELECT Gotchas

This article explains how MySQL treats backslashes in INSERT and SELECT statements, demonstrates the resulting storage differences with practical examples, and clarifies the double‑escaping rules that developers must handle to avoid unexpected query results.

Insertbackslashescaping
0 likes · 6 min read
Mastering Backslash Escapes in MySQL: Insert & SELECT Gotchas
ITPUB
ITPUB
Dec 25, 2020 · Databases

Master MySQL Index Usage: When and How Queries Leverage Indexes

This article explains how MySQL decides whether an index can be used for range scans, LIKE patterns, and ORDER BY operations, detailing key_len calculation, index key vs. filter vs. table filter distinctions, and providing concrete examples and code snippets for better query optimization.

Range ScanSortingexplain
0 likes · 10 min read
Master MySQL Index Usage: When and How Queries Leverage Indexes
ITPUB
ITPUB
Sep 7, 2017 · Databases

Master MySQL Index Usage: When and How Indexes Improve Queries

This guide explains how MySQL decides whether to use an index for range queries, LIKE patterns, and ORDER BY operations, detailing key_len calculation, index key vs filter vs table filter concepts, and practical examples for BETWEEN and sorting optimization.

BETWEENOrder Byindex
0 likes · 10 min read
Master MySQL Index Usage: When and How Indexes Improve Queries