Sql

Question

How to separate words when occur whitespace in a name in the table..For eg: i have a table contains customer name column ....1)Sachein tendulkar
2)Viru sehwag....i want output 1) Sachein
2)Viru..i want mysql query for this

Answer 1

If table name is customers and column name is customer_name

SELECT SUBSTRING_INDEX(`customer_name`, ' ', 1) FROM `customers`;