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 to load up a file into the database, which was created using mysqldump which includes SQL statements How to dump the entire contents of a database from MySQL into a file, that includes SQL type INSERT statements 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 4 + four =