Breaking News: Grepper is joining You.com. Read the official announcement!

laravel order by case insensitive

Handsome Horse answered on March 21, 2022 Popularity 8/10 Helpfulness 1/10

answer laravel order by case insensitive

related laravel search where case insensitive

laravel order by case insensitive

Comment

//i had the same issue where i was fetching data with orderBy, on a column, which was of type BLOB.
//If you have same scenario, then to fix this issue ->
//create a new column with type TINYTEXT or TEXT. Run below query to update this new column value with previous BLOB type column value.
UPDATE IGNORE `shop` SET shop_name_new = shop_name
//IGNORE here skips all rows throwing errors, stopping this query to complete.
//Use this new column value to show in frontend. 
//No need to use any special selectRaw or orderByRaw methods in query, 
//as I tried them but no need now. Laravel automatically sorts it as case insensitive value.

Popularity 8/10 Helpfulness 1/10 Language php

Source: Grepper

Tags: case-insensitive laravel php

Link to this answer
Share Copy Link

Contributed on Mar 21 2022

Handsome Horse

0 Answers Avg Quality 2/10

Closely Related Answers

laravel search where case insensitive

Comment

//if you're currently using this:
Model::where($column, 'LIKE', '%' . $value . '%' ); 

//use 'ilike' as the comparator and it will do a case-insensitive comparison:
Model::where('column', 'ilike', '%' . $value . '%')
  
//NOTE: 
//this works for PostgreSQL, might not work for MySQL

Popularity 9/10 Helpfulness 5/10 Language php

Source: Grepper

Tags: case-insensitive case

Link to this answer
Share Copy Link

Contributed on Dec 19 2022

Camouflaged Sad Dog

0 Answers Avg Quality 2/10

laravel order by case insensitive

Contents

More Related Answers

laravel order by case insensitive

Closely Related Answers

laravel search where case insensitive

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.