LTRIM to remove leading blank space from main string by MYSQL query

LTRIM to remove space Prefix to a string

SELECT LTRIM('  plus2net.com')// Output plus2net.com

LTRIM with UPDATE

To remove blank space before the name in our student table

UPDATE student SET name=LTRIM(name)

Read more on UPDATE Query

We can add space to a column and also display the same after removing space.

SELECT concat('    ',name), ltrim(concat('   ',name))  from student

Subhendu Mohapatra

Author

🎥 Join me live on YouTube

Passionate about coding and teaching, I publish practical tutorials on PHP, Python, JavaScript, SQL, and web development. My goal is to make learning simple, engaging, and project‑oriented with real examples and source code.

Subscribe to our YouTube Channel here

This article is written by plus2net.com team. https://www.plus2net.com

plus2net.com