split name on the basis of capital letter
I have a column named ‘Name’ which contains values like ‘ViratKohli’, ‘RohitSharma’, ‘SureshRaina’, ‘ObedMcCoy’. How can I get it like ‘Virat Kohli’, ‘Rohit Sharma’, Suresh Raina’, ‘Obed McCoy’ in MySQL?
I have a column named ‘Name’ which contains values like ‘ViratKohli’, ‘RohitSharma’, ‘SureshRaina’, ‘ObedMcCoy’. How can I get it like ‘Virat Kohli’, ‘Rohit Sharma’, Suresh Raina’, ‘Obed McCoy’ in MySQL?