Is ADO events suited for this?

I do not have expertise in ADO, so before writing any code, I thought
of clarifying few facts.

I have an app that would be waiting for a row to be inserted in to SQL
table; and in addition to this, one of the column should have
'specific' string. If I take the table, given below as example, my
application would like to know when the following query succeeds
SELECT * FROM log_info_table WHERE LogMessage LIKE '%pppp123qqq%',

Example: log_info_table
LogType(int) LogMessage(nvchar)
--------------------------------------------------------------------------------
1 Success ItemID:
'pppp123qqq'
1 Success ItemID:
'gggg678hhh'



Can I use ADO events to get notified?
Can I set event to get notified, ONLY when the 'LogMessage' contains
'pppp123qqq' instead of every INSERT operation?


Thanks
Ramesh

.