Scoring a MYSQL result

[anders2002]

Hi,

Is there a way to score a mysql query result not in how many rows it produces but in how many cells it returns per row that contain data and are not null?

Cheers,

Anders

 

[sleipnir214]

To the best of my knowledge, there is not query you can pass MySQL to get that information.

You can always, of course, issue the query then have some function run through the return, calculating your score.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!