: 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 appears
that somebody put one together and posted
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,
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
[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 both english and greek charakter titles.
How can I
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
.
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 titles in a UTF8
: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
; 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
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'll want
@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 like %CE%9C
10 matches
Mail list logo