Useful MySQL Functions and SQL Techniques for Data Manipulation

This article presents a collection of practical MySQL functions and SQL commands—including GROUP_CONCAT, CHAR_LENGTH, LOCATE, REPLACE, NOW, INSERT…SELECT, INSERT…IGNORE, SELECT FOR UPDATE, ON DUPLICATE KEY UPDATE, SHOW CREATE TABLE, CREATE TABLE … SELECT, EXPLAIN, SHOW PROCESSLIST, and mysqldump—explaining their purposes, usage patterns, and providing concrete example queries with results.

GROUP_CONCATON DUPLICATE KEY UPDATEchar_length

0 likes · 13 min read

Useful MySQL Functions and SQL Techniques for Data Manipulation

ITPUB

Dec 24, 2022 · Databases

Master MySQL: 13 Essential Functions and Commands Every Developer Should Know

This guide walks you through 13 practical MySQL techniques—from aggregating values with GROUP_CONCAT and measuring string length with CHAR_LENGTH, to locating substrings, replacing text, retrieving timestamps, bulk inserting data, handling duplicate keys, inspecting table structures, and using diagnostic commands like EXPLAIN and SHOW PROCESSLIST—complete with ready‑to‑run SQL examples and visual results.

GROUP_CONCATInsertNOW

0 likes · 13 min read

Master MySQL: 13 Essential Functions and Commands Every Developer Should Know

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