MySQL UNIQUE non-case sensitive?

[Anon]

$row_query = mysql_query("SELECT * FROM $toplist_mysql_table");

ok i have that... now i want it to only query from the row "webmaster_email" that is unique and i dont want this to be case sensitive... can anyone help me out? i can't find how anywhere...

thanks 🙂

~Blake

[lawnmowerman]

As long as webmaster_email is a field type that is case insensitive (per the MySQL manual), you can use:

$row_query = mysql_query("SELECT DISTINCT( webmast_email) FROM $toplist_mysql_table");

This will return each e-mail address only once, regardless of case (again, assuming that the field is a case insensitive field type, such as char or text).

Hope this helps!

-Rich

[Anon]

that did it,
thanks 🙂

~Blake

[lawnmowerman]

No problem! 🙂

-Rich