MySQL Forums
Forum List  »  General

SELECT ... WHERE ... IN (SHOW ...) -> i miss something, i need a sharp look to show me what
Posted by: Marius Boitor
Date: April 09, 2005 08:23PM

SELECT a,b,c FROM t WHERE (a = '1') AND (b = '2') AND c IN (SHOW TABLES FROM db)
---
i have a problem with the syntax here and i can see it. if anyone can give me an idea of what i'm missing i will be greatfull.
Thx, Marius
the original code: (PHP/MySQL)
$q = "SELECT id, name FROM tbl_one WHERE (act = '1') AND (liv >= '2') AND name IN ("SHOW TABLES FROM db LIKE '" . $name . "'")";

Options: ReplyQuote


Subject
Written By
Posted
SELECT ... WHERE ... IN (SHOW ...) -> i miss something, i need a sharp look to show me what
April 09, 2005 08:23PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.