I am trying to update a new field with a field named 'filename' but only want the left charactors (length of what it is -4)
I am a newbi! Please help
UPDATE photographs SET basefilename = substr(filename,0,lengh(filename)-4)
UPDATE statment
Moderator: General Moderators
Re: UPDATE statment
seems to me that you are trying to get just the filename without extension right?... if so... look here
http://php.net/manual/en/function.basename.php
and scroll down to the second example
http://php.net/manual/en/function.basename.php
and scroll down to the second example