Re: case-insensitive select?

I didn't find any reference on this matter in the PDF version of MySQL neither in Paul Dubois's MySQL book, but I think you can't use column names that can create ambiguity in a "select" statement, you can walk arround using "select * " any way. Excuse me, but why don't you change the name of the column to a more specific name like "FromCity" or something else ? Jayme. http://www.conex.com.br/jjeffman -----Mensagem Original----- De: Johan Fredrik Øhman <johan@essay.org> Para: <php-db@lists.php.net> Enviada em: terça-feira, 10 de outubro de 2000 15:39 Assunto: Re: [PHP-DB] case-insensitive select? > >Johan, > >I'm not that familiar with ASA, but what you describe is exactly what I > >would expect on an ASE server. The ways you have it coded would tell > >ASE to select the literal 'fname' for each row in the customer table. > >What are you trying to do by quoting the column name? > > Thanks for your answer. By quoting I'm atempting to avoid to conflict with > keywords. Let's say I have a column named 'from'. > > I guess SELECT FROM FROM MYTABLE would return error. > but SELECT "FROM" FROM MYTABLE would be OK. > > So if you got any other way to avoid this ambisious sentence, let me know. > PS '[]' (grackets) won't work either. > > -- > Johan Fr > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >