Re: sql search

[Andreas Kotowicz <koto@mynetix.de>]

At 12:39 18.07.99 -0500, you wrote:
>******    message to minivend-users from "Phil Welch" 
><PhilmoreW@worldnet.att.net>     ******
>
>http://www.tcx.se/Manual_chapter/manual_Problems.html#Case_sensitivity
>
>17.13 Case sensitivity in searches
>By default, MySQL searches are case-insensitive (although there are some
>character sets that are never case insensitive, such as czech). That means
>that if you search with col_name LIKE 'a%', you will get all column values
>that start with A or a. If you want to make this search case-sensitive, use
>something like INDEX(col_name, "A")=0 to check a prefix. Or use
>STRCMP(col_name, "A") = 0 if the column value must be exactly "A".

I already read this but some how it doesn't work for me. Looking for "LIKE 
'%asus%'" does just provide any stuff written asus, but not ASUS.


Andreas Kotowicz