Page 1 of 1

Mysql Select 1st Chat and Unique

Posted: Sat May 14, 2011 5:03 am
by gd77
Hello:
Trying to Select first letter(s) (a-z) and to be unique... using Like 'a' or SUBSTRING(columnname, 1, 1) = 'a';
the main problem is to make it select from a to z as first character without repetition.
Thanks in advanced.

Re: Mysql Select 1st Chat and Unique

Posted: Sat May 14, 2011 5:18 am
by gd77
Done, Fixed.
select distinct substring(col_Name,1,1) as letter from `tbl` order by letter