FN-FORUM: MySQL CAse Sensitive

date posted 3rd August 2005 18:49

Hi All
=20
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.
=20
Thanks
Paul
=20



Paul Summers
Systems Developer
=20

Digital Arts IT Consultancy
=20

Telephone. 0870 01 02 226
Fax. 0870 01 02 227
Email. [EMAIL REMOVED]
=20

http://www.daitc.com
=20

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 =
you are not the intended recipient(s) please note that any form of =
distribution, copying or use of this communication or the information in =
it is strictly prohibited and may be unlawful. If you have received this =
communication in error please return it to the sender.
=20

This message has been scanned by Symantec Enterprise AV Version 9.0 =
prior to dispatch.
=20

The views of the author may not necessarily reflect those of the =
Company. Any opinions or other information in this message that do not =
relate to the official business of the Company are neither given nor =
endorsed by it.