'Split address with multiple delimeter to multiple column in SQL [duplicate]
1808 FOX CHASE DR, GOODLETTSVILLE, TN i am trying to split it in 3 column based on , comma.
I have used select substring_index(OwnerAddress,',',1),substring_index(OwnerAddress,',',-1) from housingdata; it will give me only 2 values however i am lookking for 3 values in 3 different column.
i am using Mysql Workbench. can anyone guide on how to split string with multiple delemter in sql.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|