I'm not sure, but I think that greek characters are sorted after English
chars so try this:
SELECT DISTINCT LEFT(title,1) FROM odigos_details WHERE LEFT(title,1) >
'z' ORDER BY title
HTH,
Dusan
nikos napsal(a):
Hello list.
I want to select discinct the first letters of titles in a UTF8 table
but only the greek ones.
There are both english and greek charakter titles.
How can I exclude the english from selection?
My table is:
CREATE TABLE `odigos_details` (
`id` int(11) NOT NULL auto_increment,
`cat` tinyint(3) default NULL,
`territory` tinyint(3) default NULL,
`title` varchar(150) default NULL,
`story` text,
`link` varchar(100) default NULL,
`address` varchar(150) default NULL,
`tel` varchar(50) default NULL,
`fax` varchar(11) default NULL,
`photo` varchar(100) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8
and I run:
SELECT DISTINCT LEFT(title,1) FROM odigos_details ORDER BY title
witch is working fine.
Thank you.
Nikos
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
