LEFT

2026-02-03 08:48:37  Updated

Syntax

LEFT(str,len)

Purpose

LEFT() returns the leftmost len characters of the str string. If str or len is NULL, NULL is returned.

This function is multi-byte safe.

Examples

obclient> SELECT LEFT('oceanbase', 5);
+----------------------+
| LEFT('oceanbase', 5) |
+----------------------+
| ocean                |
+----------------------+
1 row in set

Contact Us