Re: [PHP-DB] How I can use multiple results in MySQL

2001-04-23 Thread Sigitas Paulavicius 

> SELECT name FROM cia WHERE region =
> (SELECT region FROM table WHERE name = 'Brazil');

would be:
 SELECT cia.name
FROM cia, table
WHERE cia.region=table.region
AND table.name='Brazil'



> SELECT name FROM table WHERE count =
> (SELECT max(count) FROM table);

if there may be more than one record having maximum value, you will have to
run two separate queries


Sigitas



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] How I can use multiple results in MySQL

2001-04-23 Thread Mark Roedel 

> -Original Message-
> From: Yevgeny Dyatlov [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 23, 2001 8:05 AM
> To: PHP-DB
> Subject: [PHP-DB] How I can use multiple results in MySQL
> 
> 
> 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?

MySQL doesn't support sub-selects.  

However, in many cases you can get the same result by either
reorganizing your queries or creating a temporary table.  For more info,
see

http://www.mysql.com/doc/M/i/Missing_Sub-selects.html

For example, your first query, rearranged to use joins, might wind up
looking something like

SELECT cia.name
FROM cia, table
WHERE cia.region = table.region 
AND table.name='Brazil'

For the second, I'd do something like

SELECT name
FROM table
ORDER BY count DESC
LIMIT 1


---
Mark Roedel ([EMAIL PROTECTED])  ||  "There cannot be a crisis next week.
Systems Programmer / WebMaster  ||   My schedule is already full."
 LeTourneau University  ||-- Henry Kissinger


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]