I want to SELECT on one term have the SELECT return as quickly as
possible on the first TRUE instance.
Ideally I'd like it to after the first matching case stop looking
for other matches ( for speed ) and return 1. If there's no matches
at all I want it to return 0.
This works OK but
Check manual on ISNULL or another MYSQL functions that deal with NULL and
return 0 or 1.
- Original Message -
From: S A [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 08, 2001 3:34 AM
Subject: how to get SELECT to return 0 or 1 for WHERE match ?
I want to SELECT on
I want to SELECT on one term have the SELECT return as quickly as possible on the
first TRUE instance.
Ideally I'd like it to after the first matching case stop looking for other matches (
for speed ) and return 1. If there's no matches at all I want it to return 0.
This works OK but