Mailinglisten-Archive

Re: locate - vorher order by / group by having...

Archiv Mailingliste mysql-de

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: locate - vorher order by / group by having...

Subject: Re: locate - vorher order by / group by having...
From: Falk Kuehnel <falk_(at)_salia.de>
Date: Wed, 13 Dec 2000 23:59:24 +0100
Content-Transfer-Encoding: 8BIT
In-Reply-To: <3A37ADE8.D160BD5_(at)_webelefant.de>
Old-Return-Path: <falk_(at)_salia.de>
Reply-To: mysql-de_(at)_lists.4t2.com


>Anfrage select TITEL, LOCATE('rain',FILME.TITEL) AS fit from FILME WHERE
>fit > 0 order by fit,TITEL scheitert.

Das liegt am WHERE. Sorry, daran habe ich nicht gedacht. WHERE kann nur 
vorher ausschließen, aber HAVING löst das Problem.

select TITEL, LOCATE('rain',FILME.TITEL) AS fit from FILME HAVING
fit > 0 order by fit,TITEL

Gruß
Falk

-- 
Fun is irrelevant ... http://www.totenkomisch.de/
Comedy-Events in Ihrer Nähe! --- http://comedy.cogitatio.de/

---
*** Weitere Infos zur Mailingliste und MySQL unter http://www.4t2.com/mysql

Follow-Ups:
- Re: locate - vorher order by / group by having...
  - From: Christian Dassow <c.dassow_(at)_webelefant.de>

References:
- locate - vorher order by / group by having...
  - From: Christian Dassow <c.dassow_(at)_webelefant.de>

Prev by Date: Fremdschlüssel
Next by Date: Re: AW: Datensatz "verschieben"
Prev by thread: Table von Breiten- und Längengraden
Next by thread: Re: locate - vorher order by / group by having...
Index(es):
- Date
- Thread

Home | Main Index | Thread Index

php::bar PHP Wiki - Listenarchive