Stored Procedure help

[kevin hadley]

hi, I am new to mysql so forgive my ignorance with my questions. I am trying to write a stored procedure which examines the last 3 recorded events on a test system. Each test system event creates an error code which is inserted into the table stored in mysql.

From a query perspective I can use

SELECT critError FROM histdata.jobhistory where scheduler='live_relt' and lteName='stepney' ORDER BY jobId DESC LIMIT 3;

I can then visually check the fields are the same. What I would like to do is write a stored procedure that compares these last 3 results and outputs if they are the same. Is this possible to do using stored procedures or would i need a separate piece of code in c to do this? Any help would be appreciated