string comparisons with case

[Ike]

If I have a field, `lastname`, and in the WHERE predicate of my SELECT
statement I want to test if it is LIKE 'Smith' without regards to case (i.e.
I want it to be true if it is smith or Smith or SMITH) how can I specify
this? Thanks, Ike

[strawberry]

Re: string comparisons with case


Ike wrote:

If I have a field, `lastname`, and in the WHERE predicate of my SELECT
statement I want to test if it is LIKE 'Smith' without regards to case (i.e.
I want it to be true if it is smith or Smith or SMITH) how can I specify
this? Thanks, Ike

look at BINARY

[davie]

Re: string comparisons with case


By default, MySQL searches are not case sensitive . This means that if
you search with col_name LIKE 's%', you get all column values that
start with S or s.

If you want a column always to be treated in case-sensitive fashion,
declare it with a case sensitive or binary collation.

Ike wrote:

If I have a field, `lastname`, and in the WHERE predicate of my SELECT
statement I want to test if it is LIKE 'Smith' without regards to case (i.e.
I want it to be true if it is smith or Smith or SMITH) how can I specify
this? Thanks, Ike

[Ike]

Re: string comparisons with case


"davie" <daviestrachan@ yahoo.co.ukwrot e in message
news:1160010764 .149933.319800@ m73g2000cwd.goo glegroups.com.. .

>
By default, MySQL searches are not case sensitive . This means that if
you search with col_name LIKE 's%', you get all column values that
start with S or s.

But is that true with version >= 5.0 ?

[davie]

Re: string comparisons with case

RTFM

http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html

Ike wrote:

"davie" <daviestrachan@ yahoo.co.ukwrot e in message
news:1160010764 .149933.319800@ m73g2000cwd.goo glegroups.com.. .

By default, MySQL searches are not case sensitive . This means that if
you search with col_name LIKE 's%', you get all column values that
start with S or s.

>
>
But is that true with version >= 5.0 ?