Jump to content

unsure how to word this mysql question


Sabmin

Recommended Posts

I have a table in mysql in which a field is constantly being filled with one of a thousand options.  I'm looking to find out how I can grab the 20 most recent rows for each unique option filling that field.

 

My other question is how realistic is queing up this much data if the field options were to reach a number of say 50-100 thousand options that I'm pulling the most recent 20 rows for each in terms of time it'll take to retrieve all the data.  Is the database going to be fast enough or should I not bother with this feature?

 

As always thank you very much for any help!

Link to comment
https://forums.phpfreaks.com/topic/210255-unsure-how-to-word-this-mysql-question/
Share on other sites

Works wonderfully! Thank you!

 

Unfortunately I forgot about another field I need figured in... I can get what I need done with more lines but if possible to use a single query I'd prefer to; so is there a way to get the syntax right when doing something along the lines of:

 

SELECT (option where x = y or option 2 where x = z), COUNT(id) AS c FROM table GROUP BY c ORDER BY c LIMIT 20

 

Thanks!

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.