Trimming a mysql value

Is there a way to, after receiving a value from the sql server, cut off the first four characters of the value it receives.

Say, I have an column that always has "INTO" at the beginning of the entries on every table, but I don't want to print that out to the user.

When I assign:
$value = $row["column"];
..coudl I cut off the first 4 letters? Or 5? I know how to do it in ASP..it's like
ltrim($value, 4)

That just cuts off the first four characters. Thanks

hiya...

i dont think there's a dedicated ltrim/left... but you can use substr (or wrap it up nicely into a ltrim fn)

substr(string string, int from[, int to])

(note that strings start at index 0...
INTO abcd..
012345678..
)

eg. $trimed = substr($value, 4);
with $value = "INTO 123", $trimed = " 123"

i'm sure you could use a regexp as well, but i'll leave that to someone who knows what they're talking about 😉

dom
🙂

Sweetness thanks. That was just what I was looking for.