It would depend upon the collating sequence for the field. Regards,
Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -----Original Message----- > From: nikos [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 25, 2007 10:07 AM > To: Dus(an Pavlica; mysql@lists.mysql.com > Subject: Re: select first letters > > Seems that work in v. 4.1.21 > but not in 5.0.27 > > Thank you Dusan > > Dus(an Pavlica wrote: > > 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]
