MySQL - select first word from string using SUBSTR

In this small article, i would like to share with you how to extract the first word of string in sql query. i did that using SUBSTR, LOCATE and If statement. Yesterday, i was working on my laravel project and i require to get first name from fulname column like as example: "Hardik Savani" Hardik Savani is a full name but i just need to get first work "Hardik" from fullname of users table in phpm.....

Posted On December 2, 2017