On 2 Jan 2009, at 20:38, jbv wrote:
So the query is quite straightforward, for instance :
SELECT Col1, Col2, Col3, Col4 FROM myTable WHERE Col1 = "toto" OR
Col2 = "toto" OR Col1 = "tata" OR Col2 = "tata" OR Col1 = "titi" OR
Col2 = "titi"...
up to possibly 50 elements.
I think all those OR conditions will cause a slowdown. Another
approach might be to use UNION and IN. (Warning: I've never done a
query of this kind.)
(
SELECT Col1, Col2, Col3, Col4
FROM myTable
WHERE Col1 IN ('toto,tiki,tata,etc.')
)
UNION DISTINCT
(
SELECT Col1, Col2, Col3, Col4
FROM myTable
WHERE Col2 IN ('toto,tiki,tata,etc.')
)
Good luck!
Cheers
Dave
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
