List:General Discussion« Previous MessageNext Message »
From:Stefan Hinz Date:July 25 2001 4:28pm
Subject:Re: Sorting w/ leading articles ignored
View as plain text  
Dear Zhang,

check for the "regular expression" section in the MySQL manual. You can
filter out any patterns you want with RegExp :)


  Stefan Hinz
  Geschäftsführer / CEO iConnect e-commerce solutions GmbH
  #  Gustav-Meyer-Allee 25, 13355 Berlin
  #  Tel: +49-30-46307-382  Fax: +49-30-46307-388

----- Original Message -----
From: "Bin Zhang" <bzhang@stripped>
To: "Msql-Mysql-Modules" <msql-mysql-modules@stripped>; "Mysql"
Sent: Wednesday, July 25, 2001 11:20 AM
Subject: Sorting w/ leading articles ignored

> Can this be done?  What I want is to generate a list of journal sorted
> the titles, ignoring the leading articles (the, a, an, etc.).  If
there is
> no SQL statement for this, How could I do this w/ DBI or PHP?  I am
> mysql 3.23.40 on  Solaris 7. Thanks for any advise.
> Bin
> ---------------------------------------------------------------------
> Before posting, please check:
>   (the manual)
>           (the list archive)
> To request this thread, e-mail <mysql-thread80562@stripped>
> To unsubscribe, e-mail
> Trouble unsubscribing? Try:

Start up problemsRichard Reina2 Apr
  • Re: Start up problemsSasha Pachev2 Apr
  • Re: Sorting w/ leading articles ignoredDodger25 Jul
  • Re: Sorting w/ leading articles ignoredStefan Hinz25 Jul