regular expression

Hi All,

Can someone tell me how to use query to find or group records which using regular expression in MySQL?

eg. tableID = from 0001 to 9999

1) I want to find all records that match tableID the first and the third is digit 1.(eg: 1017,1717, 1614......), if i use query below ,

select * from tablename where tableID in ( tableID REGEXP "^1.1.")

only return me tableID =1 .

2) how to group records by tableID which are all the third digit is 1, ( eg: 2212, 3313,7412...) or all the second digit is 1 (e.g 2122, 3133,8153....)

TIA

Richard

Maby:

SELECT * FROM tablename WHERE id BETWEEN 0 AND 999

Good luck
Bjorn