MySQL query to extract first word from a field

SELECT SUBSTRING_INDEX(`name`, ' ', 1);

php sql mysql

Here you go :)

SELECT SUBSTRING_INDEX( `field` , ' ', 1 ) AS `field_first_word`FROM `your_table`

php sql mysql

select     substring(test_field, 1, instr(test_field, ' ')) from     test_table

CodeHunter