select substring using negative length

[eluser]orladin[/eluser]
resitNo
-----------
S00001
MPP00003
S00002
FS00004

Hi there,
I'm trying to query column resitNo using substring. I want it read without last 5 digits
I try following query it doesn't work.

SELECT *
FROM loan
WHERE SUBSTRING( resitNo, 0, -5 ) = 'S'

tq

[eluser]Aken[/eluser]
MySQL supports regular expression matching:

Code:

SELECT * FROM loan WHERE resitNo REGEXP 'S[0-9]{5}'

[eluser]Andreas Bergström[/eluser]
Read wrong, please delete post.