How to split commas in where conditionColumn1. Column2
Row3 value1, value3,value2
I need to achieve a sql query.
Condition1 : Column2 should come in 'where' condition'.
Condition2 : In case of two or three or more value(with splitted by commas), it should automatically come in 'where' condition divided by 'or'
select * from tablenamr where (case when column1=row3
Then column2=value1 or column2=value3 or column2=value2)