Re: help with replacing OR in query

dear erick,
insted of putting OR just Put AND if you want that both the constraints must be satisfied. like
select xyz from table1
where col1=* and col2=*;
my email is
vismaymandloi_at_rediffmail.com

> p.s., if you reply, kindly CC me as well.
>
> hi, i have the following SQL query
>
> select col1 from table1
> where
> col2 = 'xxx' or col3 = 'xxx'
>
> how can i get rid of this OR? due to my table design and the logic
> involved, i have to check both these 2 columns (in a search function). i
> cannot concaneate them to make a third column because i need to check for
> exact match but for both the columns.
>
> so what can i do to replace the OR, because the OR makes the query skip any index.
>
> thanks in advance for any insight/ideas!
>
> .ep
Received on Tue Aug 13 2002 - 11:20:22 CEST