Re: IN ANY subqueries

2006-09-12 Thread Peter Van Dijck
table); Ref: http://dev.mysql.com/doc/refman/5.0/en/any-in-some- subqueries.html Thanks ViSolve DB Team - Original Message - From: Ben Lachman [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Sunday, September 03, 2006 10:33 AM Subject: IN ANY subqueries I

Re: IN ANY subqueries

2006-09-06 Thread Philippe Poelvoorde
- Original Message - From: Ben Lachman [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Sunday, September 03, 2006 10:33 AM Subject: IN ANY subqueries I have a string comparison that I would like to do against a short list of constant strings. at the moment I am using the syntax SELECT

Re: IN ANY subqueries

2006-09-04 Thread Visolve DB Team
@lists.mysql.com Sent: Sunday, September 03, 2006 10:33 AM Subject: IN ANY subqueries I have a string comparison that I would like to do against a short list of constant strings. at the moment I am using the syntax SELECT id FROM t1 WHERE name IN('s1', 's2', 's3', ...); However, this limits me

Re: IN ANY subqueries

2006-09-04 Thread Ben Lachman
://dev.mysql.com/doc/refman/5.0/en/any-in-some- subqueries.html Thanks ViSolve DB Team - Original Message - From: Ben Lachman [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Sunday, September 03, 2006 10:33 AM Subject: IN ANY subqueries I have a string comparison that I would like

IN ANY subqueries

2006-09-02 Thread Ben Lachman
I have a string comparison that I would like to do against a short list of constant strings. at the moment I am using the syntax SELECT id FROM t1 WHERE name IN('s1', 's2', 's3', ...); However, this limits me to exact matches and I'd like to move to a caparison expersion that lets me match