How do I favor certain records from an sql query? Such as 50% need to match a certain criteria?

Sounds like a good question, though it's not totally clear to me what you want to achieve.

It sounds like you want mix some randomness into the result. Randomness is not usually in the nature of SQL, but I suppose the RAND() function could be helpful here.

Another way to get 50% into the mix is to simply select two result sets (with the same number of rows - and none repeated in the two) and put them together with a UNION. In this case you would select the ones with collection="TEST_1" and then the ones with NOT collection="TEST_1".

If you could clarify what you need and if any of this was in the right direction, it would be helpful.

Thanks,
Jakob

It sounds like you want mix some randomness into the result. Randomness is not usually in the nature of SQL, but I suppose the RAND() function could be helpful here.

http://www.neu92.com/