LIKE | BestHub

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 TuningIndexesLIKE

0 likes · 17 min read

MySQL Query Optimization Guidelines and Best Practices

Zhuanzhuan Tech

Aug 31, 2022 · Databases

MySQL Equality Comparison Ignores Trailing Spaces – Causes and Precise Query Techniques

This article investigates why MySQL treats strings with trailing spaces as equal during "=" comparisons, explains the underlying PAD SPACE collation rule, and demonstrates how to perform exact matches using LIKE and BINARY operators with practical examples and code snippets.

DatabaseLIKEMySQL

0 likes · 7 min read

MySQL Equality Comparison Ignores Trailing Spaces – Causes and Precise Query Techniques

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.

DatabaseEscapeINSERT

0 likes · 6 min read

Handling Backslashes in MySQL INSERT and SELECT Statements