Hello All,
I have a table with a column called "bus_name" varchar(100) which is used in a
Business Name search form. I need to make the Business Name that is entered into
the search form case in-sensitive to the column "bus_name" IE. If we have a
entry in the column "bus_name" "The Happy Shop", and someone enters "the happy
shop" or "THE HAPPY SHOP", it will still return a match. If I add the attribute
"BINARY" to the colunm "bus_name" will this make it case-insensitive or is there
another way to do this within the SQL query??
TIA,
Mike(mickalo)Blezien
========================================
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225) 686-2002
=========================================
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
