I have a very simple question. There is a product table in my database and in that table I have a 'Category' column .In that column there are variables like watch,jewellery,accesories etc. But table is not that clean as it should be. For example just for accesories, there are more than one name. Lower case, upper case... different ways to dedicate 1 category. I want to take all of these types as 1 and put them in my chart. For example for accesories I have 'accesories' and 'ACCESORIES' when I write it as if (lower(category)='accesories',category). It takes both of the names separately. How ca I write it as 1 while I dont lose any data.
It worked while the difference is only upper case, lower case or space but when we have a different difference between 2 variables,I still can't merge them. The table that I mentioned also uses multiple languages for the same variable so I also need to merge them in 1 variable. Do you know how to do that??