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@stripped]
> Sent: 19 November 2009 08:41
> To: mysql@stripped
> 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
>
>
>
