Re: search field into MySQL

It is a database setting. http://www.mysql.com/documentation/mysql/bychapter/manual_Problems.html#Case_sensitivity Peter On Thu, 24 Oct 2002, Seabird wrote: > Hi everyone, > > I'm encountering a problem searching a DB. I wish for the input to not be > case sensitive. if someone looks for AA they may also type aa or aA or Aa. > This one is simple because its 2 or three letters. > > I also have entries that contain "Aviation Management Corporation" they > should not be searched by case sensitive. How to do this. Convert the DB > (23000 entries) or change some code.... > > Here is my "result" code: > > print "<table border=1>\n"; > $query = "SELECT * FROM $table WHERE Field1 LIKE '%$icao%' $ton > Field2 LIKE '%$name%' $ton2 > Field3 LIKE '%$country%' > ORDER BY $sort"; > $result = mysql_query($query) or die("Error in query"); > > while($row = mysql_fetch_assoc($result)){ > print "<tr>\n" > ."<td>" . $row['Field1'] . "</td>\n" > ."<td>" . $row['Field2'] . "</td>\n" > ."<td>" . $row['Field3'] . "</td>\n" > ; > } > > Thanx, > Jacco > > print "</tr></table>"; > > > -- > http://seabird.jmtech.ca > > Attitude is Everything! > But Remember, Attitudes are Contagious! > Is Yours worth Catching???? > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > --------------------------------------------------------------------------- Peter Beckman Systems Engineer, Fairfax Cable Access Corporation beckman@purplecow.com http://www.purplecow.com/ ---------------------------------------------------------------------------