Select on type varchar is not case sensitive, you can make it case sensitive with the BINARY option:
SELECT * FROM table_name WHERE BINARY column LIKE '$searching_criteria'; Koen On 06/10/05, Ron Piggott <[EMAIL PROTECTED]> wrote: > Is SELECT typically case sensitive? Is there a way to make it case > sensitive? (In the example below can $searching_criteria become case > sensitive?) > > SELECT * FROM table_name WHERE column LIKE '$searching_criteria'; > > Ron > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
