MySQL - Im using PLSQL and need to select only even numbered events from column

Asked By Leigh Thomas on 08-May-13 04:47 AM
the events are labelled 'abcd12 - event 01' etc...  the event names are not always labelled as such some have more or less characters, i need to extract the numbers from the end of the event name and select those greater than 3 and even.

thanks for your help