Mysql Select String Function Problem

[ner Staiger]

I want to select records in my table when it matches a row that ends with a particular value.eg.if 'oop' is found at the end of a particular record it select the recordPls how can i go about itthanks