Use exists() and doesntExist()

1. exists()

Instead of:

Please use:

2. doesntExist()

Instead of:

Please use:

3. Compare

With mysql laravel will compile to:

• count()
  
  select count(*) as aggregate from `posts` where `slug` = 'abc'

  1 2	select count(*) as aggregate from `posts` where `slug` = 'abc'

  
  Counts how many rows of data meet the condition. Had to run from beginning to end of data table to compare and count => slow .
• exists()
  
  select exists(select * from `posts` where `slug` = 'abc') as `exists`

  1 2	select exists(select * from `posts` where `slug` = 'abc') as `exists`

  
  If the data line is found, it will return true, otherwise it will return false. The best case scenario is that the data line that meets the condition is at the beginning of the data table.

4. Conclusion

• Query speed is faster than using count() .
• The code will be more semantically explicit (exists: exists – does not exists: does not exist).

5. Reference

• Laravel – Determining If Records Exist

6. About me

Hope this sharing will help you newbie a bit in the process of learning about Laravel.

I’m Cong Thanh Thank you for following my article, if you have any questions, please comment below.