Case Sensative 2 Not

Ivains

Hi Everyone,

I am trying to find either a tutorial or piece of coding that will help bring the results I want.

What I have is a query that will look names in the table and produce the results of all names. However the names are in the table more than once so I used the "group by" which works except if I inputted the name lets say Mickey Mouse one time and then another like mickey mouse it will group them individually vs together.

My results will look like:

Mickey Mouse
mickey mouse

vs.

Mickey Mouse

How can I turn off the case sensativity?

$q2 = mysql_query ("SELECT Name FROM log GROUP BY Name ORDER BY Name LIMIT $start,$limit");

Thanks for any help or guidance.

mrhappiness

GROUP BY LOWER(columnname)

but you don't know whether you get Mickey Mouse or mickey mouse

btw: don't use group by for such things

SELECT DISTINCT `name`
FROM log
ORDER BY `name`

SELECT DISTINCT BINARY `name`
FROM log
ORDER BY `name`

compare them please

btw: name is varchar or text and not blob, is it?

Ivains

Hi mrhappiness,

Thanks for replying. I tried all 3 to no avail.

$q2 = mysql_query ("SELECT DISTINCT Name FROM log ORDER BY Name LIMIT $start,$limit");

This code gave me the same results. Didn't change the output.

$q2 = mysql_query ("SELECT DISTINCT BINARY Name FROM log ORDER BY Name LIMIT $start,$limit");

This code returned 0 results.

$q2 = mysql_query ("SELECT Name FROM log GROUP BY LOWER(Name) ORDER BY Name LIMIT $start,$limit");

This code gave me the same results. Didn't change the output.

And the file type is varchar(100).

LordShryku

Lower your selection criteria.

SELECT DISTINCT LOWER(name)
FROM log
ORDER BY LOWER(name)

If you want to make the first letters uppercase or something after that, use php to do it.

Ivains

Thank you both mrhappiness & LordShryku.