Rev cgi & mySQL (again)

[Dave Cragg]

Sorry, syntax error in my last post:

Should be:



(
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.')
)