title: Split address with multiple delimeter to multiple column in SQL
body: <p><code>1808  FOX CHASE DR, GOODLETTSVILLE, TN</code> i am trying to split it in 3 column based on <code>,</code> comma.</p>
  <p>I have used <code>select substring_index(OwnerAddress,',',1),substring_index(OwnerAddress,',',-1)  from housingdata;</code> it will give me only 2 values however i am lookking for 3 values in 3 different column.</p>
  <p>i am using Mysql Workbench. can anyone guide on how to split string with multiple delemter in sql.</p>