Matt Chatterley wrote:
One option would be to 'union' the two queries (assuming the columns are the
same type and length), allowing you to run one query string:
Select serial from blacklist where serial = x
Union
Select serial from seriallist where serial = x
Would return 1 or 2 rows, depending on
h 2004 07:39
To: MySql
Subject: Getting around 2 queries
I currently run this, which is 2 hits to the database.
Select serial from blacklist where serial = '23'
Select serial from seriallist where serial = '23'
I only desire to know if either of the 2 has at least one row, I
Scott Haneda <[EMAIL PROTECTED]> wrote:
> I currently run this, which is 2 hits to the database.
>
> Select serial from blacklist where serial = '23'
> Select serial from seriallist where serial = '23'
>
> I only desire to know if either of the 2 has at least one row, I am only
> testing for exi
I currently run this, which is 2 hits to the database.
Select serial from blacklist where serial = '23'
Select serial from seriallist where serial = '23'
I only desire to know if either of the 2 has at least one row, I am only
testing for existence here. Is there some way I can get around 2 que
