I think the "point" of a question is to get the correct answer.
The correct answer was given.
David Lloyd wrote:
>>Specify the fields you want in your query.
>>SELECT stat_id, stat_name, stat_data FROM build_stats
>>WHERE stat_date LIKE ...
>I think you miss the point of the question. What if you have table with
>50 fields and you just don't want field 45, 46 and 48? It would be much
>easier to use an except clause here rather than have to specify 47
>(this mysql query spam filter is spam)