Mike Nolan <[EMAIL PROTECTED]> writes:
>> I need to check whether a SQL subexpression (to be used in WHERE
>> clause), e.g.:
> I've never tested it from Perl, but could you use 'explain select'
> to see if it parses? It won't actually execute it if it does.
Consider input along the line of
> I need to check whether a SQL subexpression (to be used in WHERE
> clause), e.g.:
I've never tested it from Perl, but could you use 'explain select'
to see if it parses? It won't actually execute it if it does.
--
Mike Nolan
---(end of broadcast)---
I need to check whether a SQL subexpression (to be used in WHERE
clause), e.g.:
colname > 200
or an entire SELECT statement, e.g.:
SELECT * FROM t1, t2 WHERE colname > 200
is syntactically valid. Is there a quick (and also safe) way to do this?
I'm thinking of doing "SELECT ... FROM ... WHERE
