Re: [Phpgroupware-developers] Re:Follow Up: Questions from New User/Developer

[Chris Weiss]

that's why I had the lower() on BOTH sides of the LIKE.

Ashleigh Gordon (address@hidden) wrote*:
>
>/>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
>
>
>
>_______________________________________________
>Phpgroupware-developers mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>