How to replace all string values from a column to another value?

Question

I want to replace all values from a column, like for example, to replace all values from lane column to 'All lanes' value. I tried to use REPLACE function : REPLACE(lane, '%', 'All lanes') but it does not work that way though. Any thoughts? Thanks in advance!

lane
WA-OR
TX-NY
MA-NJ

Expected output:

lane
All lanes
All lanes
All lanes

Gordon Linoff · Accepted Answer · 2021-01-30 01:58:24Z

2

Just use update:

update t
    set lane = 'All lanes';

Note this permanently affects all rows. If you just want the result in a query:

select 'All lanes' as lane
from t;

answered Jan 30, 2021 at 1:58

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

2 Comments

hachiko Over a year ago

Thanks! Are there any ways that we could use REPLACE in this case?

Gordon Linoff Over a year ago

REPLACE() would not be appropriate for what you want to accomplish.

Collectives™ on Stack Overflow

How to replace all string values from a column to another value?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related