How to get the first word of a string using MySQL

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 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