Case Question

I currently have a PHP script performing the following query mysql_query("SELECT * FROM Stuff WHERE Release LIKE \"%$var2%\"",$var1) It works great except that the search is coming out case sensitive. According to the MySQL Docs all searches are done without case sensitivity. I just have

Re: Case question on inserting data

So sprach Dave Carter am Fri, May 25, 2001 at 06:21:08PM -0400: > Is there a way inside of mysql to force the case of data being inserted into > the database??? -> http://www.mysql.com/doc/S/t/String_functions.html LOWER() / LCASE() and UPPER() / UCASE() Alexander Skwar -- How to quote: htt

Case question on inserting data

Is there a way inside of mysql to force the case of data being inserted into the database??? Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 - Before posting, please chec