I have a list of subjects, such as Linux, Open Source, and the
World Wide Web. The subjects are stored in MySQL and being retrieved
via php. I currently organize them alphabetically with MySQL's ORDER
BY ASC argument, however, if there is a preceding the or a then
that is considered as part of
On 2006-11-06 Dotan Cohen wrote:
I have a list of subjects, such as Linux, Open Source, and the
World Wide Web. The subjects are stored in MySQL and being retrieved
via php. I currently organize them alphabetically with MySQL's ORDER
BY ASC argument, however, if there is a preceding the or
On 06/11/06, Christian Hammers [EMAIL PROTECTED] wrote:
On 2006-11-06 Dotan Cohen wrote:
I have a list of subjects, such as Linux, Open Source, and the
World Wide Web. The subjects are stored in MySQL and being retrieved
via php. I currently organize them alphabetically with MySQL's ORDER
BY
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)