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 get a list of my MySQL tables? How to set text to have a Capital letter and then lowercase letters 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 + seven = eight