Re: printing columns other than the search criteria

On 08/11/16 09:21, John Levine wrote:
>> Select * from archive where rain > '{0}' print _at_datetime @baro
>
> Are datetime and baro fields in the record? If so you mean this:
>
> select datetime, baro from archive where rain > {0};
>
> If they're something else, you need to give us more clues about
> what you are trying to do.
>
My assumption was that what he wanted on a PER LINE BASIS was

print everything EXCEPT baro and datetime UNLESS it was raining.

Easy to do in an application, not possible in MYSQL

-- 
Future generations will wonder in bemused amazement that the early 
twenty-first century’s developed world went into hysterical panic over a 
globally average temperature increase of a few tenths of a degree, and, 
on the basis of gross exaggerations of highly uncertain computer 
projections combined into implausible chains of inference, proceeded to 
contemplate a rollback of the industrial age.

Richard Lindzen