Menu

Articles

A Complete Guide to the MySQL EXPORT_SET() Function

This article provides an in-depth look at the MySQL EXPORT_SET() function, including its syntax, usage, and practical examples.

A Complete Guide to the MySQL CHARACTER_LENGTH() Function

This article provides an in-depth look at the MySQL CHARACTER_LENGTH() function, including its syntax, usage, and practical examples.

A Complete Guide to the MySQL NOT RLIKE Operator

This article provides an in-depth look at the MySQL NOT RLIKE operator, including its syntax, usage, and practical examples.

A Complete Guide to the MySQL NOT REGEXP Operator

This article provides an in-depth look at the MySQL NOT REGEXP operator, including its syntax, usage, and practical examples.

A Complete Guide to the MySQL NOT LIKE Operator

This article provides an in-depth look at the MySQL NOT LIKE operator, including its syntax, usage, and practical examples.

MySQL GROUP_CONCAT Truncated? Check group_concat_max_len

Fix truncated MySQL GROUP_CONCAT results by checking group_concat_max_len, max_allowed_packet, and warning 1260 before raising the session limit.

A Complete Guide to the MySQL ABS() Function

Learn MySQL ABS() syntax, NULL and signed BIGINT behavior, numeric conversion, and index-friendly range filters.

MySQL Warning 1287: BINARY Operator Is Deprecated

MySQL 8.0.27+ deprecates BINARY expr. Use CAST(expression AS BINARY) for bytewise comparison, and learn when a _bin collation differs.

MySQL Error 3942: Empty ROW() in a VALUES Table Constructor

Fix MySQL Error 3942 (HY000) from an empty ROW() in a standalone VALUES table constructor, and distinguish it from INSERT … VALUES syntax.

MySQL Error 1250: UNION ORDER BY Cannot Reference Source Tables

Fix MySQL Error 1250 (42000) in a UNION query by ordering on an output alias or position, or by sorting a derived table.