Count Errors in Database [RESOLVED]
Posted: Mon Jul 05, 2010 4:24 pm
I have a database of some 1 million records, there is one field in the database that contains an error code. I need to search through all records and count the amount of individual errors.
EXAMPLE:
----------------
Field name -> event_desc
ErrorManager.storeError(): name:7725878458375 time: Tue Jun 03 12:59:19 EDT 2010 code: 9909 data:667,D,555,345345354
I need to somehow read the "code: 9909" and count the total amount of them that exist between a specified date range in the database. There are also multiple other error numbers that need to be counted as well.
If someone could steer me in the right direction that would be excellent. What functions should I be using, etc...?
Any help would be greatly appreciated.
Thanks,
EXAMPLE:
----------------
Field name -> event_desc
ErrorManager.storeError(): name:7725878458375 time: Tue Jun 03 12:59:19 EDT 2010 code: 9909 data:667,D,555,345345354
I need to somehow read the "code: 9909" and count the total amount of them that exist between a specified date range in the database. There are also multiple other error numbers that need to be counted as well.
If someone could steer me in the right direction that would be excellent. What functions should I be using, etc...?
Any help would be greatly appreciated.
Thanks,