Re: where in multiple columns
Posted by:
Nick Roper
Date: September 07, 2004 02:20AM
With your existing table structure:
SELECT strFileName FROM catalog_images
WHERE
nCategoryA="1" OR
nCategoryB="1" OR
nCategoryC="1" OR
nCategoryD="1" OR
nCategoryE="1"
Depending on the way that you are using the nCategory columns, you might find that using an ENUM or SET data type is more efficient.
Nick
--
Nick Roper
Subject
Written By
Posted
September 06, 2004 05:11PM
Re: where in multiple columns
September 07, 2004 02:20AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.