search is not case insensitive
| From: | Dr Michael Daly | Date: | Sun, 31 Oct 2010 04:47:16 +0000 |
| Subject: | search is not case insensitive | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-309162@lists.php.net to get a copy of this message | ||
Hi
Using a php search form produces a nil return on any information that is
capitalised within a mysql database; retrieval is fine for non-capitalised
data. Could someone tweak this please? The relevant code I think is as
follows:
// Description is a BLOB in MySQL... we need to UPPER the blob
//values to make the search case-insensitive.
$query = "SELECT C.*, A.surname, A.name, A.surname_prefix, A.id AS user
FROM pbcs_user A, pbcs_join_table_user_app B, pbcs_appointment C ".
"WHERE A.id = B.user_id AND B.appointment_id = C.id ".
"AND LOWER(C.description) LIKE '%".strtolower($search_for)."%' AND
C.start_time > $start_time AND C.start_time < $end_time ORDER BY
C.start_time";
$result = pbcs_db_query($query);
Thanks
Michael
Melb, Aust.