LTRIM to remove space Prefix to a string

MySQL Ltrim

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

Read more on CONCAT

Subscribe to our YouTube Channel here

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

plus2net.com

▼ More on String

String Functions
substring_index to get part of a string from a delimiter
substring Part of string from a position
concat: adding a substring to all data present in a field
character_length: Number of chars in a string
locate: searching for a matching string inside field data
character_length: length of string present in a field for each record
ucase:lower to upper and upper to lower case conversion functions
left: left part of the string data in a field
replace: replace part of a sting with sub string in a field
length: string length function
reverse: string reverse function
repeat: string repeat number of times
RIGHT: Right part of the string
lpad: string padding from left
like: String pattern matching against record

Queries INSERT UPDATE

Aggregate Queries AVG ( Average ) SUM MIN MAX

SQL Video Tutorials

✖

We use cookies to improve your browsing experience. . Learn more

FORUM . Contact us

©2000-2023 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer