#querybuilder

The database query builder in Laravel provides a simple, intuitive interface for generating and performing database queries. It works with every one of Laravel's supported database systems and may be used to conduct most operations on the database in your application. This article will teach you how to utilize select like queries in a Laravel application. Laravel eloquent, in theory, provides a query builder that helps us to handle that kind of situation in MySQL. This is quite simple to use, or you could say a no-brainer. "Query Builder" deserves a standing ovation. It can assist you in writing a Like query in Laravel, and keep in mind that it is utilized with the Where condition. Like the query, Laravel Eloquent is mostly used to search the particular value of the table's selected column. As a result, you can use one of the methods listed below.

1. WHERE Condition with Like Query in Laravel with Query Builder

Laravel Query Builder (QueryBuilder / DB Facade)

Query builder is a function that you can assemble SQL statements to query when you get records from the database, but you can easily assemble it.

Even if you are not familiar with SQL statements, this function allows you to query in a proper format, which is a very convenient function. It is also a function that is provided roughly in recent PHP frameworks.

This time, I will describe the…

where(function ($query){ $query->where()->where()...}

이와 같이 클로저를 전달 가능.

이는 where 조건절 내부에 sql문 자체를 생성함. DB::raw와 비슷

ex) $query->where(’id’,1)->where(’name’,’jwh’)        -> select * from xxx where id=‘1′ and name=‘jwh’;

If you want to join non-releated entities:

$qb = $this->_em->createQueryBuilder(); $qb->select('E'); $qb->from(Exam::class, 'E') ->join(TrainingSchema::class, 'TS', Join::WITH, 'TS.id = E.trainingSchema') ->where('1=1');

If have a relation between entites:

$qb = $this->_em->createQueryBuilder(); $qb->select('E'); $qb->from(Exam::class, 'E') ->join('E.trainingSchema', 'TS') ->where('1=1');