Re: FN-FORUM: MySQL CAse Sensitive

date posted 3rd August 2005 19:13

On Wed, 3 Aug 2005, Paul Summers wrote:

> Have a MySQL query issue - I have a site that requires users to enter
> their surname to validate a login, The data stored in the database could
> be in any case, i.e. SMITH, smith or Smith - Is there a way of getting
> the query so search the surname field ignoring case? I've Googled but
> not sure I'm search the right term.

Not sure why you'ld want to do that?

Isn't 'like' case insensitive?

> Please Note:
> This message contains information which is confidential and may also be =
> privileged. It is for the exclusive use of the intended recipient(s). If =



This is a public mailing list with a public archive. Any chance of
disabling the message?

--
Graeme -
Outlook Express user? - http://home.in.tum.de/~jain/software/oe-quotefix/
http://wiki.workalone.co.uk/index.php?page=RulesForPosting