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

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-2022 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer