Laravel - Where null and Where not null eloquent query example

if you are a starter or learner laravel then you have in mind how to check where null or where not null condition using laravel eloquent model when you are writing eloquent query. if you write query for SQL then it is very easy syntax and families with where null and not null condition. In this small tutorial i will let you know how you can write query for where null and where not null conditio.....

Posted On April 2, 2018

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