On 2006-11-06 Dotan Cohen wrote:
> > Make a second column that only contains
> > ALTER TABLE table ADD cooked_subject;
> > UPDATE table SET cooked_subject = ereg_replace('^(a|the) ', '', subject);
> > (I don't know how the regular expression function was called exactly but
> > you get the idea)
> >
> > SELECT subject FROM table ORDER BY cooked_subject;
> >
> > Of course you could also put the regular expression in the SELECT but that
> > would be slower.
>
> Would it really slow it down that much?
"slow" always depends.. if the table has only 200 rows and the query is run
twice a day, don't care about speed :)
-christian-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
