Query using subset of string

[fraser5002]

Hi i have the following query for my database.

 

$query = "SELECT * FROM entries WHERE id = '$u'";

 

Is there anyway i can alter this to use all but the last 3 characters from "id"  for the query  ( will need to obviously determine the length of id for this entry in the database first )  i.e similar to the operation of the php statement substr()

 

 

Any Ideas?

 

Thanks

 

 

[ebmigue]

$query = "SELECT * FROM entries WHERE LEFT(id, LENGTH(id) - 3) = '$u'";

 

Hope it helps.