SQL Query for Multi-Values In An Encoded String
Consider a table with an textual column that encodes multi-values like so:
1 |
1|US;2|CA;3|MX |
How can we query for all rows using an OR criteria? For a single value, it’s quite easy by searching for the string (in this case, an...