[RESOLVED] Averaging/High/Low times on SQL results

[neilmasters]

Hi all,
I recently posted a request for optimisation methods for SQL queries for which I received some brilliant responses. After this i also started logging execution times of pages on an application I maintain.

table: execution
fields:
exec_id(INT, AUTO_INCREMENT)
exec_stamp(TIMESTAMP)
exec_section(LONGTEXT)
exec_time(VARCHAR)

SQL Query I have:

SELECT exec_section, exec_time, exec_time, exec_time
FROM execution
GROUP BY exec_section

Can someone assist me or point me in the right direction to change the fields exec_time, exec_time and exec_time to display the average, highest and lowest.

Any input you might have will be more than brilliant I am sure. Thanks for your time.

Neil

[bradgrafelman]

neilmasters wrote:

display the average,

AVG()

neilmasters wrote:

highest

MAX()

neilmasters wrote:

and lowest

MIN()

[neilmasters]

Pretty damn simple tbh. Ta for your help.