Is it possible...

[roopurt18]

I'd like to do something like:

 

SELECT 'foo' AS bar From some_table

 

But have a specific number of rows return, even though they'd all be identical.  If I want 4 rows, I can attach a 'LIMIT 4' on the end of the query, but the table has to have at least 4 rows in it; what can I do if I'm not sure the table has that many rows?

 

Thanks!

[SnowControl]

Just loop it 4 times then.

 

 

 

for ($i=0 ; 4 > $i ; $i++) {

echo "$foo";

}

 

 

And if you dont want this if there are 4 or more rows in the sql result, just check it with a simple "if (mysql_num_rows($result) < 4)".

 

 

[roopurt18]

I have to do it without any programming logic, hence the reason I put it in the MySQL forum.

 

[Illusion]

SELECT 'foo' AS bar From some_table EXISTS select count(*) as cnt from some_table having cnt >=4

[fenway]

SELECT 'foo' AS bar From some_table EXISTS select count(*) as cnt from some_table having cnt >=4

 

That's pretty much what I would suggest... I use mutex tables that have a lot of rows for that very purpose for other nitfy things, too.