character class in a LIKE statement

wxdqz

New Member
Using MySQL, does anybody know a way of selecting all records in a specified field beggining with a set of specified characters from a character class (ie ^[a-e])

i.e. All records whos title begin with the letter A-E without having to use lenghty LIKE statments

Thanks

Stew
 
Back
Top