'Split address by delimer and create new column in MySQL Workbench

I want to split address based on delimeter (,) extract number from address and split address using (,)

the code i have written select substring_index(Propertyaddress,',') from housingdata; however it shows an error saying incorrect parameter call to native function i am using mysql workbench.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source