Re: Non case-sensitive SQL Query
| From: | Jon Evans | Date: | Fri, 18 Aug 2000 11:55:50 +0000 |
| Subject: | Re: Non case-sensitive SQL Query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-2152@lists.php.net to get a copy of this message | ||
Hi Anders,
On Fri, Aug 18, 2000 at 12:44:06PM +0200, Anders Dannberg wrote:
> I need some help on how to make a NON case-sensitive sql query. I use the
> following query which outputs what i need:
>
> $query = "SELECT * FROM user INNER JOIN maintable ON user.number =
> maintable.number WHERE name LIKE 'Anders%'";
How about:
$query = "SELECT * FROM user INNER JOIN maintable ON user.number =
maintable.number WHERE UPPER(name) LIKE 'ANDERS%'";
Jon.
--
Jon Evans / Red Internet Ltd. / +44 1869 337977