Adding a field with mySQL
I'm trying to add a new field to an existing data set via mySQL (my first time doing this). The new field will take data from my existing data set (Product Name) and re-assign a new name leveraging a case statement.
Below is my code. I'm currently receiving an syntax error, which I'm looking for assistance on. Additionally, I want to validate this is the correct way to add a new field with mySQL integration.
WHEN `Product Name` like '%YOUTUBE%' then 'YouTube'
WHEN `Product Name` like '%AUDIO%' then 'Audio'
WHEN `Product Name` like '%FENCING%' then 'Geo-Fencing'
END AS new product name