RE: Select through characters

2009-11-19 Thread misiaQ
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

Re: Select through characters [SOLVED]

2009-11-19 Thread nikos
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