How to perform a case in-sensitive search on a case sensitive MySQL database?


Problem :

How to perform a case in-sensitive search on a case sensitive MySQL database?
For example, name = Test & name = test.
then the query returns both Test & test.
How to make a query for this..??



Solution :

$query = "SELECT * FROM table WHERE LOWER(name) = '" . strtolower($name) . "'";

Mysql Tutorials

Mysql Howto..

mysql how to create optimum query for these table

how to insert and update mysql table in php [closed]

How to connect Apache Solr with mysql

MySql how to query a substring from a mediumtext?

How to convert a search string coldfusion-loop into a MySQL stored procedure?

How to perform grouped ranking in MySQL

How to Link PHP Sub Categories(Pages) Dynamically

How to run a sql file in MySql Workbench without to load it?

How to transpose MySQL rows and repeat column headers?

PHP: How to grab an array checkbox value and then insert each individual result into a database query?

How do i get access to the elements inside of my mysql_fetch_row

Dynamic JavaScript slideshow

How to get last row of repeating column in php mysql

How to perform the following join in mysql?

How to make a User Privacy Table in MYSQL

How to order values in ascending order from MySQL query with PHP?

How to access MySQL from a remote computer (not localhost)?

PHP -> MySQL | How to handle select result [duplicate]

How to export some rows of a mysql table with where clause from a php script?

how to autoincrement a string value fetch from mysql

How do you pass the value of one query in to another query MySQL without using PHP

How Do I Calculate the Number of the Following Week?

mysql SELECT many to many GROUP_CONCAT (how to get all records)

how to Replace a Column values of my database with other value of different column in same table in mysql

How to tune self-join table in mysql like this?

How to select all distinct values except one in MySQL?

how to add a different css to last mysql query result using php

how to echo a value that is an unselected option from the database in mysql php

How to ordering the create_date and update_date in mysql

How to find email with more than 2 dots using REGEXP MySQL function?