Select first word - mysql query

Question

i need to select only the first name (that is the first word) of the user.

For example, Andy Jones, only select Andy

Any idea?

thanks

Answer 1

Take a look at substring_index.

select substring_index(field, " ", 1) ....

Answer 2

If I understand, your FirstName and LastName are in one column. You can achieve this using user defined functions.

Example:

SELECT SPLIT_STR(name, ' ', 1) as firstname FROM users;

Read following post for more options:

• Split value from one field to two