RE: weird comparison problem

2003-01-26 Thread Loren McDonald
>From the manual: 6.3.2.2 Case-Sensitivity BINARY The BINARY operator casts the string following it to a binary string. This is an easy way to force a column comparison to be case-sensitive even if the column isn't defined as BINARY or BLOB: mysql> SELECT "a" = "A"; -> 1 mysql> SELECT B

weird comparison problem

2003-01-25 Thread Pag
This msg keeps bouncing off the list. First off, thanks for the hint on displaying several pages of news. :-) Am having a bit of a weird problem with a SELECT on my MYSQL database: If i use this: SELECT * FROM tablehere WHERE userid = '$uid' AND password = '$pwd' with $uid and $pwd bein