SQL SELECT query UPPER in LARAVEL 5.4

Question

i have a problem in my search form. In my database all data is in upper case , so when i input lower case letter in search field it do not gives any result. So i trying to find out how to make my form insensitive.

This is the model:

// chassis
    public function chassis($chassis)
    {
        return $this->builder->where('model_type_en', 'LIKE', "%$chassis%");
    }

Do you have any ideas how i can use upper(model_type_en) in this function?

Possible duplicate of [How can I search (case-insensitive) in a column using LIKE wildcard?](http://stackoverflow.com/questions/2876789/how-can-i-search-case-insensitive-in-a-column-using-like-wildcard) — M. Eriksson, May 14 '17 at 05:44

score 0 · Accepted Answer · answered May 14 '17 at 06:00

0

// chassis
    public function chassis($chassis)
    {
        $str = strtoupper($chassis);
        return $this->builder->where('model_type_en', 'LIKE', "%$str%");
    }

answered May 14 '17 at 06:00

Amir

4,089
4
16
28

It works! Im new in laravel, thank you for your help. – Dmitry Malys May 14 '17 at 06:03

SQL SELECT query UPPER in LARAVEL 5.4

1 Answers1