RE: select first letters

TECTED] > Sent: Wednesday, April 25, 2007 12:15 PM > To: Jerry Schwartz; mysql@lists.mysql.com > Subject: Re: select first letters > > Finaly I use ord(). > Thank you. > > Jerry Schwartz wrote: > > The multi-byte extension doesn't seem to include one, but > it ap

Re: select first letters

mysql@lists.mysql.com *Subject:* Re: select first letters Jerry do you know if there is a php command that returns ascci number of a letter? I'll want to use chr() command because I want to transfer via link the letter to next page but greek characters transformed to something li

RE: select first letters

06032 860.674.8796 / FAX: 860.674.8341 _ From: nikos [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 25, 2007 11:41 AM To: Jerry Schwartz; mysql@lists.mysql.com Subject: Re: select first letters Jerry do you know if there is a php command that returns ascci number of a letter? I'

Re: select first letters

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

RE: select first letters

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

Re: select first letters

Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: nikos [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 25, 2007 9:28 AM To: mysql@lists.mysql.com Subject: select first letters Hello list. I want to select discinct the first letters of t

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 naps

RE: select first letters

> From: nikos [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 25, 2007 9:28 AM > To: mysql@lists.mysql.com > Subject: select first letters > > Hello list. > I want to select discinct the first letters of titles in a UTF8 table > but only the greek ones. > There are

Re: select first letters

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 tabl

select first letters

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`