RE: FN-FORUM: MySQL CAse Sensitive

date posted 3rd August 2005 19:21

[EMAIL REMOVED] wrote:
> Hi All
>
> 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.
>
> Thanks
> Paul

I believe mysql searching is case sensitive by default

http://dev.mysql.com/doc/mysql/en/pattern-matching.html

At least for regular text fields.

HTH,

Dai

--
TechnologyAngel
http://www.technologyangel.co.uk/