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

Reply via email to