Mysql query replace first empty string

Question

I have many fields that contains extra space in start, like:

" RTX 3060"
-^

I want to remove first extra space from all fields of this table.

What I tried:

UPDATE table set field = concat( '', substring(field , 1)) where left(field ,1)=' ';

Return 0 result!

I think you need 2 on substring insted of one. But still there are couples I can think of UPDATE table set field = concat( '', substring(field , 2)) where field LIKE " %" or UPDATE table set field = substring(field , 2) where field LIKE " %" — Rajesh Paudel
– Rajesh Paudel, Commented Aug 18, 2022 at 19:07
@RajeshPaudel Backticks format code, asterisks are simply for bold. — tadman
– tadman, Commented Aug 18, 2022 at 19:10
@tadman thanks I have a habit of putting three backticks maybe that's why it wasn't working. I realised i could put one instead of three. Thank You — Rajesh Paudel
– Rajesh Paudel, Commented Aug 18, 2022 at 19:12
@RajeshPaudel One for inline, three for block form, which I believe only works in answers, etc. — tadman
– tadman, Commented Aug 18, 2022 at 19:13

Alaindeseine · Accepted Answer · 2022-08-18 20:10:37Z

2

Try with this statement, it will remove only the first space char of field is it's a space:

UPDATE `table` 
SET column = SUBSTRING(column,2)
WHERE SUBSTRING(column, 1, 1) = ' ';

edited Aug 18, 2022 at 20:10

answered Aug 18, 2022 at 19:59

Alaindeseine

4,6341 gold badge17 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mike · Accepted Answer · 2022-08-18 19:23:26Z

0

Try using the LTRIM function. The syntax looks something like this:

UPDATE table SET column = LTRIM(column);

answered Aug 18, 2022 at 19:23

Mike

162 bronze badges

2 Comments

Alaindeseine Over a year ago

LTRIM remove ALL first chars, the question is about removing the first extra space, not all.

Adison Masih Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Mysql query replace first empty string

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related