Re: Stop query on first match

[Jeff Smelser]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Monday 07 June 2004 12:49 am, Emmanuel van der Meulen wrote:
> I've looked in several books and searched Google but cannot get a way of
> doing this.  It seems Oracle has a 'FIRST' in their select which they use
> for such a use case.  But I do not see anything for MySql anywhere.

If your using a later mysql, you could use sub query with limit.

Other then that, splitting the query is the only think off hand.

- -- 
 I am under the influence of sugar, caffeine, and lack of sleep, and
	   should not be held responsible for my behavior.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFAxAMEld4MRA3gEwYRAgc5AJ0behkfDwijlpSANX1oXsRfNtwmKgCeOF4b
j9366DtZYNuo2j0aTvQsudY=
=ecrd
-----END PGP SIGNATURE-----