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:ni...@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 > > >
