Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5BEJAE05813; Mon, 11 Jun 2001 10:19:11 -0400 (EDT) (envelope-from martin@bugs.unl.edu.ar) Received: by bugs.unl.edu.ar (Postfix, from userid 1004) id 25CC82AB3A; Mon, 11 Jun 2001 11:19:33 +0300 (GMT) Content-Type: text/plain; charset="iso-8859-1" From: =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= To: pgsql sql Mailing List , pgsql-general@postgresql.org Subject: ORDER BY what? Date: Mon, 11 Jun 2001 11:19:31 +0300 X-Mailer: KMail [version 1.2] MIME-Version: 1.0 Message-Id: <01061111193103.29653@bugs> Content-Transfer-Encoding: 8bit X-Archive-Number: 200106/367 X-Sequence-Number: 10708 I have a quite complex select query on postgres (obviously :-) ) using PHP (which is not the problem at the moment) which has some text searches using LIKE. My question is: "How can I write an ORDER BY statment so that it's ordered by the amount of matches it gets?" Is this posible without getting ichy with the programing? Saludos.... :-) -- Cualquiera administra un NT. Ese es el problema, que cualquiera administre. ----------------------------------------------------------------- Martin Marques | mmarques@unl.edu.ar Programador, Administrador | Centro de Telematica Universidad Nacional del Litoral -----------------------------------------------------------------