i have a table that has
'number'
1234
12 34
1 2 34
1 2 3 4
ect...
so, im wondering how can i write a query that will remove all spaces?
something like
update `table` set number = REPLACE( ' ', '', (select 'number' from `table`));
is there anything that will do this?
Close. I believe you could write something like this:
update `table` set number = REPLACE( number, ' ', '');
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With