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

It was my first thought Jerry, but it didn't work to me... Thanks anyway! Jerry Schwartz wrote: Aren't all of the Greek characters distinct from all of the English characters? If so, you could test just the first letter of the field against an IN condition, where the IN (...) lists all of the Gr

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

Aren't all of the Greek characters distinct from all of the English characters? If so, you could test just the first letter of the field against an IN condition, where the IN (...) lists all of the Greek characters. If it's easier to type, you could use a NOT IN (...) test and list the English lett

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