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.
Mysql Select 1st Chat and Unique
Moderator: General Moderators
Re: Mysql Select 1st Chat and Unique
Done, Fixed.
select distinct substring(col_Name,1,1) as letter from `tbl` order by letter
select distinct substring(col_Name,1,1) as letter from `tbl` order by letter