String Extraction Techniques in MySQL Using Left, Right, Substring, and Substring_Index
Extracting Characters from the Left Side
Use left(source_text, char_count) to obtain a specified number of charcaters from the start of a string.
SELECT LEFT('datastream_process', 9);
-- Result: datastrea
Extracting Characters from the Right Side
Use right(source_text, char_count) to retrieve a defined number of characters from the end of a st ...
Posted on Wed, 12 Aug 2026 16:11:23 +0000 by SensualSandwich