Search Case Insensitive

QuestionsSearch Case Insensitive
Ty asked 4 years ago

I'm using latest full version. Database is mysql

Need insensitive case searh

Typing in "Dog" will work
Typing in "dog" will not work.

My code:

$col = array();
$col["title"] = "Brand";
$col["show"] = array("list"=>true, "edit"=>true, "view"=>true);
$col["searchoptions"]["sopt"] = array("bw");
$col["name"] = "brand";
$col["width"] = "20";
$col["editable"] = true;
$cols[] = $col;

1 Answers
Abu Ghufran answered 4 years ago

Refer this query for mysql case sensitive search:
http://stackoverflow.com/questions/3936967/mysql-case-insensitive-select

Your Answer

15 + 8 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating / 5. Vote count:

We are sorry that this post was not useful for you!

Let us improve this post!