converting query in Query Builder

Question

how can I convert this query in query builder.

public function ajaxsearch(string $value = null) //for search, from sidebar
{
    return $value ? Teacher::select('id', 'efirst', 'esecond')
        ->whereRaw("UPPER(efirst) LIKE '" . strtoupper($value) . "%'")
        ->limit(7)
        ->get() : [];
}

I tried the following but how to convert cases to uppercase in laravel.

DB::table('teachers')
    ->select("id", "efirst", "esecond")
    ->limit(7)->get() : [];

you're using query builder in both cases. Dont transform to upper in your database query, do it client side. — N69S
– N69S, Commented Nov 4, 2019 at 8:24

Yasin Patel · Accepted Answer · 2019-11-04 09:44:14Z

1

Try this query :

Teacher::select('id', 'efirst', 'esecond')
->whereRaw("UPPER(efirst) LIKE '" . strtoupper($value) . "%'") 
->limit(7)->get();

for DB Query :

return $value ?
DB::table('teachers')
->select('id', 'efirst', 'esecond')
->whereRaw("UPPER(efirst) LIKE '" . strtoupper($value) . "%'")
->limit(7)
->get():[];

edited Nov 4, 2019 at 9:44

answered Nov 4, 2019 at 9:05

Yasin Patel

5,7818 gold badges37 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Fayakon Over a year ago

it returned nothing on fronend, here is log; [2019-11-04 09:20:11] local.INFO: array ( 0 => 'select id, UPPER(efirst), esecond from teachers where UPPER(efirst) LIKE \'%A%\' limit 7', 1 => array ( ), 2 => 6.01,

Yasin Patel Over a year ago

what you exactly want? columns in upper case? or compare records in upper case?

Fayakon Over a year ago

i want to get record from database(any case) and show result in upper case.

Yasin Patel Over a year ago

in your column efirst it is stored in upper case?

Fayakon Over a year ago

it has come values in lower case and some upper.

|

Collectives™ on Stack Overflow

converting query in Query Builder

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related