[PHP-DB] Case-insensitive SELECT From: David B. Small (dbsmall <email protected>)
Date: 08/15/00

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>