Re: How to select rows from Mysql with case senstive ??

Hey try this, though there are probably better ways, "SELECT * FROM foo WHERE name REGEXP '^[PHP]'"; James ""Bass¨Ð¦õªv"" <98350193j@polyu.edu.hk> wrote in message news:9egfot$cfu$1@toye.p.sourceforge.net... > Hi , > By defualt , select rows from Mysql is case insenstive . > For exmaple , > select * from foo where name = 'PHP' > select * from foo where name = 'php' > is the same > > how can i do a queny which > select * from foo where name = 'PHP' > is success > but > select * from foo where name = 'php' > fail ?? > > given that name = 'PHP' in the database > > thx > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >