TRIM, LTRIM, RTRIM in MySQL - Step-by-Step Execution

Concept Flow - TRIM, LTRIM, RTRIM

Input String

↓

Choose Trim Function

↓

TRIM

↓

Remove spaces

↓

Return trimmed string

The input string is passed to one of the trim functions which remove spaces either from both ends (TRIM), only the left/start (LTRIM), or only the right/end (RTRIM), then returns the cleaned string.

Execution Sample

MySQL

SELECT TRIM('  hello  ') AS trimmed_both,
       LTRIM('  hello  ') AS trimmed_left,
       RTRIM('  hello  ') AS trimmed_right;

This query trims spaces from both ends, left end, and right end of the string ' hello ' and shows the results.

Execution Table

Step	Function	Input String	Action	Output String
1	TRIM	' hello '	Remove spaces from both ends	'hello'
2	LTRIM	' hello '	Remove spaces from left/start only	'hello '
3	RTRIM	' hello '	Remove spaces from right/end only	' hello'
4	End		All functions executed	Results returned

💡 All trim functions processed the input string and returned their respective trimmed results.

Variable Tracker

Variable	Start	After TRIM	After LTRIM	After RTRIM
input_string	' hello '	' hello '	' hello '	' hello '
trimmed_both	NULL	'hello'	'hello'	'hello'
trimmed_left	NULL	NULL	'hello '	'hello '
trimmed_right	NULL	NULL	NULL	' hello'

Key Moments - 3 Insights

Why does LTRIM not remove spaces at the end of the string?

LTRIM only removes spaces from the left/start side of the string, so spaces on the right/end remain intact as shown in execution_table row 2.

Why does RTRIM keep spaces at the start of the string?

RTRIM only removes spaces from the right/end side, so spaces at the start/left remain, as seen in execution_table row 3.

What does TRIM remove compared to LTRIM and RTRIM?

TRIM removes spaces from both ends of the string, unlike LTRIM or RTRIM which remove spaces from only one side, as shown in execution_table row 1.

Visual Quiz - 3 Questions

Look at the execution_table, what is the output of LTRIM on the input ' hello '?

A 'hello '

B ' hello'

C 'hello'

D ' hello '

💡 Hint

Check execution_table row 2 under Output String for LTRIM.

At which step does the function remove spaces from both ends?

A Step 2

B Step 1

C Step 3

D Step 4

💡 Hint

Look at the Function and Action columns in execution_table.

If the input string had no spaces at the start, how would LTRIM's output change?

A It would remove spaces from the end

B It would remove spaces from both ends

C It would return the string unchanged

D It would add spaces at the start

💡 Hint

LTRIM only removes spaces from the left/start side, so if none exist, output stays same (see variable_tracker).

Concept Snapshot

TRIM(string) removes spaces from both ends.
LTRIM(string) removes spaces from the left/start only.
RTRIM(string) removes spaces from the right/end only.
Use these to clean unwanted spaces in text data.
They return the trimmed string without changing internal spaces.

Full Transcript

This visual execution shows how the MySQL functions TRIM, LTRIM, and RTRIM work on the string ' hello '. TRIM removes spaces from both ends, LTRIM removes spaces only from the left/start, and RTRIM removes spaces only from the right/end. The execution table traces each function's input, action, and output. The variable tracker shows how the string changes after each function. Key moments clarify common confusions about which side spaces are removed from. The quiz tests understanding by referencing the execution steps and outputs. The snapshot summarizes the functions' behavior for quick recall.