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 tried “SELECT
CONCAT(
SUBSTRING(name, 1, LOCATE(‘ ‘, name) – 1), — First name
‘ ‘, — Space
SUBSTRING(name, LOCATE(‘ ‘, name) + 1) — Last name
) AS full_name
FROM dim_players;
“. But it’s not working.
New contributor
Sanil Kumar Barik is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.