Select through characters

--------------080006050701040200050706
Content-Type: text/plain; charset=ISO-8859-7
Content-Transfer-Encoding: 7bit

Hello list
I have a list of names with english and greek characters.
How can select them separately?
I mean, only greeks or only english.

thank you,
Nikos

--------------080006050701040200050706--

RE: Select through characters

Hi,

If the efficiency is the key factor I would suggest to create a trigger on
insert and update and mark the rows in a separate column instead of
executing some fancy string checks during select.

Regards,
m.

-----Original Message-----
From: nikos [mailto:nikos@qbit.gr]
Sent: 19 November 2009 08:41
To: mysql@lists.mysql.com
Subject: Select through characters

Hello list
I have a list of names with english and greek characters.
How can select them separately?
I mean, only greeks or only english.

thank you,
Nikos


------------------------------------------------------------ ----------
Wst±p do Klubu Gracza, wygraj telefon!
Sprawdz >>> http://link.interia.pl/f243a


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Select through characters [SOLVED]

--------------080402000604030902060607
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I find a solution that works:

SELECT writer_id, writer FROM writer WHERE writer REGEXP '^[A-Z]+' ORDER
BY writer

Thank you all
Nikos

misiaQ wrote:
> Hi,
>
> If the efficiency is the key factor I would suggest to create a trigger on
> insert and update and mark the rows in a separate column instead of
> executing some fancy string checks during select.
>
> Regards,
> m.
>
> -----Original Message-----
> From: nikos [mailto:nikos@qbit.gr]
> Sent: 19 November 2009 08:41
> To: mysql@lists.mysql.com
> Subject: Select through characters
>
> Hello list
> I have a list of names with english and greek characters.
> How can select them separately?
> I mean, only greeks or only english.
>
> thank you,
> Nikos
>
>
> ------------------------------------------------------------ ----------
> Wst?p do Klubu Gracza, wygraj telefon!
> Sprawdz >>> http://link.interia.pl/f243a
>
>
>

--------------080402000604030902060607--