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 :)

Regards,

--
  Stefan Hinz
  Geschäftsführer / CEO iConnect e-commerce solutions GmbH
  #  www.js-webShop.com www.iConnect.de
  #  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"
<mysql@stripped>
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
by
> 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
using
> mysql 3.23.40 on  Solaris 7. Thanks for any advise.
>
> Bin
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread80562@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-hinz=js-webshop.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>

Thread
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