LTRIM to remove space Prefix to a string
LTRIM() removes leading spaces. Use RTRIM() for trailing spaces or TRIM() for both ends.
SELECT LTRIM(' plus2net.com') -- Output plus2net.comLTRIM with UPDATE
To remove blank space before the name in our student tableUPDATE student SET name=LTRIM(name)SELECT CONCAT(' ',name), LTRIM(CONCAT(' ',name)) FROM student
Subhendu Mohapatra
Author & Instructor at plus2net
I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.
Connect:
Subscribe to our YouTube Channel here
This article is written by plus2net.com team.
https://www.plus2net.com
SQL Video Tutorials