|
From: | Ashleigh Gordon |
Subject: | [Phpgroupware-developers] Re:Follow Up: Questions from New User/Developer |
Date: | Fri, 22 Feb 2002 11:26:26 +1100 |
User-agent: | Mozilla/5.0 (Windows; U; Win98; en-US; rv:0.9.8) Gecko/20020204 |
/>Why not just do
$sql .= " lower($f) LIKE lower('%$query%') OR ";
/Because then all the data must be formatted as lower case to get any matches. Since I don't want to do that, I have to search for lowercase, UPPERCASE and Sentence Case, since the database contains all three types.
Ashleigh Gordon
[Prev in Thread] | Current Thread | [Next in Thread] |