SQL Data Cleaning
LEFT
Pulls a specified number of characters for each row starting from the beginning i.e. the left side.
product_idproduct_name
1Apple iPhone 13
2Samsung Galaxy S21
3Google Pixel 6
SELECT product_id, LEFT(product_name, 3) AS abbreviated_na...
wooblygeek.hashnode.dev3 min read