matchoo Posted September 13, 2007 Share Posted September 13, 2007 Hey there, I am using MySQL 5.1 I have an HTML grid of 16 different images. Each image has an img_type. I want to return exactly 16, with img_type prioritized as follows: If there are 16 img_type = 'people' I want to return them all If there are less than 16 img_type = 'people' I want to return as many as possible, and populate the rest with img_type = 'other' Again, I need exactly 16 images, but comprised of different types based on how many 'people' are in the database. Is this possible using CASE statements? If so, I would love a little help and a generic example. Thanks. -Matt Quote Link to comment Share on other sites More sharing options...
effigy Posted September 13, 2007 Share Posted September 13, 2007 SELECT * FROM table ORDER BY IF(type='people', 0, 1) LIMIT 16 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.