Re: [PHP-DB] Case-insensitive SELECT From: Doug Semig (dougslist <email protected>)
Date: 08/15/00

Could you test to see if this works:

SELECT ... WHERE UPPER(fieldname) LIKE UPPER('value')

Doug

David B. Small was heard at 12:57 PM 8/15/00 -0700 to say:
>Apologies in advance for what is assuredly a naive question.
>
>I think I understand the SELECT...WHERE...LIKE query form (although I'm
>still not sure why, with ODBC at least, I must use % instead of *...or why
>it even works)
>
>But suppose I want to find all rows of "table" in which "field" is "Field
>Name"....
>
>I'd use "SELECT * FROM tale WHERE field='Field Name'"
>
>If I now wanted it to match on 'Field Name', "Field name", "field name",
>"Field" etc., but not "Field Value"
>
>I could do some string manipulations, and perform many selects.
>But is there a more efficient way of expressing wildcards (either in SQL or
>in PHP's interface to it)?
>(eg, I'd love to say field LIKE [F|f]ield[| [N|n]ame] or something like
>that)
>
>-----------------
>David B. Small
>dbsmall <email protected>
>
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>