PHP LIKE case sensitive?

[NETSYNC]

Currently I am using LIKE in a query to find people by name.  But it seems that if I am looking for Tony and put ton it will not find it.  I am using %ton% in the query.  I MUST have a capital T if the name is in the database like that.  Its a mysql database.  How can I make it find it regardless of case sensitivity?

 

Thanks!

[QuickOldCar]

By default mysql is supposed to be case insensitive, not sure why yours would not be.

I'm using MySQL 5.0.51b

I use a multiple select query like below and for all it finds everything.

 

if ($search == "user_begins_characters") {
    $result = mysql_query("SELECT * FROM users WHERE username LIKE '".$search_words."%' ORDER BY $display $order LIMIT $startrow,$posts_per_page" );
$total_count = mysql_query("SELECT * FROM users WHERE username LIKE '".$search_words."%'");
} elseif ($search == "user_contains_characters") {
    $result = mysql_query("SELECT * FROM users WHERE username LIKE '%"."$search_words"."%' ORDER BY $display $order LIMIT $startrow,$posts_per_page" );
$total_count = mysql_query("SELECT * FROM users WHERE username LIKE '%"."$search_words"."%'");

[NETSYNC]

Dang.  It is a Windows server does that matter?  Very confusing. 

[fenway]

Dang.  It is a Windows server does that matter?  Very confusing. 

It's not -- that's crazy talk.

 

You're using the (default) case-insensitive collation -- that's a good thing.

 

If you want a case-sensitive match, then collate as BINARY. -- see here.