convert mysql query to laravel query builder

by 

\DB::table('cars')
   ->join('garage', 'garage.id', '=', 'cars.garage')       
   ->where('garage.name', 'main')

The above solves the garage and cars part, but you never specified what is aliased to p. If p is a different table then you need to add another call to join() and making the following

 \DB::table('cars')
   ->join('garage', 'garage.id', '=', 'cars.garage')
   //<Other table join goes here for table aliased to p>
   ->where('garage.name', 'main')
   ->select(['p.id', 'p.name', 'p.price'])
   ->get();

More Related Contents:

  1. Laravel Migration Error: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
  2. Is there a way to “limit” the result with ELOQUENT ORM of Laravel?
  3. How can I implement single table inheritance using Laravel’s Eloquent?
  4. Laravel join with 3 Tables
  5. Laravel Eloquent group by most recent record
  6. INNER JOIN Results from Select Statement using Doctrine QueryBuilder
  7. “General error: 1005 Can’t create table” Using Laravel Schema Build and Foreign Keys
  8. Laravel Eloquent Ignore Casing
  9. Creating MYSQL Procedure in Laravel 4 Migrations
  10. Laravel – search with multiple keywords against multiple columns with the search result to be ordered in relevance
  11. How do I set the time zone of MySQL?
  12. SQL statement is ignoring where parameter
  13. How to set initial value and auto increment in MySQL?
  14. Types in MySQL: BigInt(20) vs Int(20)
  15. Differences between INDEX, PRIMARY, UNIQUE, FULLTEXT in MySQL?
  16. How does MySQL process ORDER BY and LIMIT in a query?
  17. When should I use a composite index?
  18. Generating a random & unique 8 character string using MySQL
  19. How can I restore the MySQL root user’s full privileges?
  20. Mysql adding user for remote access
  21. Compare dates in MySQL
  22. Laravel: connect to databases dynamically
  23. MySQL root password change
  24. MySQL: How to select records for this week?
  25. how to cast the hexadecimal to varchar(datetime)?
  26. MySQL Select Query – Get only first 10 characters of a value
  27. Rank() over Partition by in mysql
  28. How we can find domain name using MySQL and regular expression
  29. How to recover just deleted rows in mysql?
  30. In MySQL SERVER 8.0 the PASSWORD function not working

Leave a Comment