There are two ways to do this using MID and LOCATE or by just using SUBSTRING_INDEX a. SELECT MID(,1,LOCATE(‘ ‘,)) FROM b. SELECT SUBSTRING_INDEX( , ‘ ‘, 1 ) FROM How to get the first word of a string using MySQL ← How can I capitalise each word in a MySQL text string without using PHP How to add a primary key index to a table and ignore and remove duplicates → You May Also Like How do I extract the 1st position of a character string that are numbers and then order by number using MySQL How to display database records which are so many days old How do I get the last occurence of a character from a string using MySQL Leave a Reply Cancel replyYour email address will not be published. Required fields are marked *Comment * Name * Email * Website Math Captcha eighty nine − = eighty eight