Home:ALL Converter>Split address by delimer and create new column in MySQL Workbench

Split address by delimer and create new column in MySQL Workbench

Ask Time:2022-02-23T23:29:45         Author:alex

Json Formatter

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.

Author:alex,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/71239785/split-address-by-delimer-and-create-new-column-in-mysql-workbench
yy