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

score 21 · Accepted Answer · answered Jun 22 '11 at 03:14

21

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

answered Jun 22 '11 at 03:14

Suroot

4,315
1
22
28

score 1 · Answer 2 · edited May 23 '17 at 12:10

1

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

edited May 23 '17 at 12:10

Community

1
1

answered Jun 22 '11 at 03:14

Naveed

41,517
32
98
131

score 0 · Answer 3 · answered Jun 22 '11 at 03:14

For something like this you would normally put the first and last name in their own columns. If you cannot, then you can get the index of the first space, then substring(0,index of the first space). I would really recommend though that you split that into two columns, if you can.

Select first word - mysql query

3 Answers3