TRIM, LTRIM, RTRIM in MySQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the TRIM function do in MySQL?

TRIM removes spaces or specified characters from both the beginning and the end of a string.

beginner

How does LTRIM differ from TRIM?

LTRIM removes spaces only from the left (start) side of a string.

beginner

What is the purpose of RTRIM in MySQL?

RTRIM removes spaces only from the right (end) side of a string.

beginner

Write a MySQL query to remove spaces from both ends of the string ' hello '.

SELECT TRIM(' hello ') AS trimmed_string; -- Result: 'hello'

intermediate

Can TRIM remove characters other than spaces? How?

Yes, TRIM can remove other characters by specifying them. For example, TRIM(BOTH 'x' FROM 'xxhelloxx') removes 'x' from both ends.

Which function removes spaces only from the start of a string in MySQL?

A LTRIM

B RTRIM

C TRIM

D SUBSTR

LTRIM removes spaces from the left (start) side of the string.

What will SELECT TRIM(' data ') return?

A 'data '

B ' data'

C ' data '

D 'data'

TRIM removes spaces from both ends, so the result is 'data'.

Which function removes spaces only from the right side of a string?

A RTRIM

B LTRIM

C TRIM

D LEFT

RTRIM removes spaces from the right (end) side of the string.

How do you remove the character 'x' from both ends of 'xxhelloxx' in MySQL?

A TRIM('xxhelloxx')

B LTRIM('xxhelloxx')

C TRIM(BOTH 'x' FROM 'xxhelloxx')

D RTRIM('xxhelloxx')

TRIM with BOTH and character specified removes that character from both ends.

If you want to remove spaces only from the right side of a string, which function should you use?

A LTRIM

B RTRIM

C TRIM

D REPLACE

RTRIM removes spaces from the right side only.

Explain the difference between TRIM, LTRIM, and RTRIM functions in MySQL.

Think about which side of the string each function affects.

How can you use TRIM to remove a specific character other than space from a string?

TRIM is flexible and can remove characters you specify.