How I can use multiple results in MySQL
| From: | Yevgeny Dyatlov | Date: | Mon, 23 Apr 2001 13:04:56 +0000 |
| Subject: | How I can use multiple results in MySQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-8810@lists.php.net to get a copy of this message | ||
Hello,
I'm cann't using query to MySQL like this:
SELECT name FROM cia WHERE region =
(SELECT region FROM table WHERE name = 'Brazil');
And
SELECT name FROM table WHERE count =
(SELECT max(count) FROM table);
I want to select COLUMN_NAME in TABLE where ID is max,
how I can do it?
--
Best regards,
Yevgeny mailto:rus_php_user@mail.ru