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 the latest date and time in an SQL query How do I extract the 1st position of a character string that are numbers and then order by number using MySQL How do I get a list of my MySQL tables? Leave a Reply Cancel replyYour email address will not be published. Required fields are marked *Comment * Name * Email * Website Math Captcha 24 − seventeen =