[PHP] mysql - SUBSTRING

[andreas \(@work\)]

hi,

if i use SUBSTRING(field,pos,len) in a SELECT statement it works fine

but i cant work it out how to use this function in the WHERE clause 

 ... WHERE  SUBSTRING(field,pos,len) LIKE "ABC"
 ... WHERE SUBSTRING(field,pos,len) = 'ABC'
 ... WHERE SUBSTRING(field,pos,len) LIKE 'ABC'

none of them work

is this not possible or whats wrong ?


thank you

andreas