LTRIM to remove space Prefix to a string
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 studentSQL String References TRIM : Removing space from both sides of the string RTRIM() : Removing space from RIGHT of the string
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