How to only edit certain strings in column?

Question

I have table in a sql table that looks like this:

column
1
2
welcome from henry
welcome from beth
welcome
3
4

How do I only edit the values that have 'Welcome from' to become only 'Welcome'?

New column:

1
2
welcome
welcome
welcome
3
4

I can not edit the table, have to do this in select statement.

Lukasz Szozda · Accepted Answer · 2019-06-13T17:57:39.487

1

You could use:

UPDATE tab
SET col = 'welcome'
WHERE col LIKE 'welcome %'

EDIT:

Unfortunately I cant update any tables, I can only do it select statements

SELECT CASE WHEN col LIKE 'welcome %' THEN 'welcome' ELSE col END AS col
FROM tab

edited Jun 13 '19 at 17:57

answered Jun 13 '19 at 17:49

Lukasz Szozda

Unfortunately I cant update any tables, I can only do it select statements. – RustyShackleford Jun 13 '19 at 17:55
@RustyShackleford That's not a problem – Lukasz Szozda Jun 13 '19 at 17:58

score 0 · Answer 2 · edited Jun 13 '19 at 17:58

0

UPDATE table_name 
SET column_name = 'VALUE YOU WANTS TO ADD IN PLACE OF OLD'
WHERE column_name LIKE 'old_value %;'

edited Jun 13 '19 at 17:58

forpas

answered Jun 13 '19 at 17:55

Creator

2 Answers2