database krone

hello,
i dont know whether this is exactly a database question.
i have a table in mysql which contains some records. if a particular field is yes i want an e-mail to be sent to the administrator everyday else no action should be taken...so basically i want to check the field everyday at a particular time to see if the value is 'Y' .pls help me as to how to do it...
i have to run a kron...but should i give a select statement?? how do i check whether the value in the field is 'Y'
thanks

You can run a php script (or perl, or whatever) via cron to do this...basically, you would do this:

result set = select * from table where field = 'Y'

foreach row in result set send mail....