Question

How do you write an UPDATE to remove specific words in SQL?

Question:

1. Write SQL to remove 'Airlines' from any carrier that has it. For example, if 'Delta Airlines' is in the table, your SQL should change that value to just 'Delta'. This must be a single query that addresses all records that have 'Airlines' in them, and should fix them all at the same time. It must be written with the assumption that other records containing 'Airlines' could exist, and if they did exist, it should address them as well.

Note: Table name: Airlines

Column Name: AirlineName

Values: (Virgin Atlantic, Frontier Airlines, Southwest Airlines, Delta Airlines)

Answer 1

Answer:

We use the Replace function to replace the Airline keyword in the table. It will search for Airlines in AirlineName column and make it as null wherever Airlines present.

UPDATE Airlines
SET AirlineName = replace(AirlineName, 'Airlines', ' ')
WHERE AirlineName LIKE '%Airlines';

Output:
Rows affected:4

Let me know in case if you have any doubts. Thanks and All the best.