[RESOLVED] PHP/MySQL and concat

[wscreate]

I have a php script that updates a mysql table data field. I could use concat to do this, but I need the data to be added to the "beginning" of the table field rather than to the end which is what concat does.

Below is an example of my code. Is there anything similar to concat that will add the data to the table field at the beginning?

Thanks.

--------- EXAMPLE CODE --------------
$query = "UPATE mytable SET Response=concat(Response,'Let me know if you need further assistance.') WHERE ID = '$ID'";

// Table "Response" looks like the following after the query.

This is the existing data that was in the table before concat.
Let me know if you need further assistance

// What I need it to do, is to append the data to the "beginning" of the table data. Like so.

Let me know if you need further assistance
This is the existing data that was in the table before concat.

[NogDog]

You're going to kick yourself....

$query = "UPATE mytable 
SET Response=concat('Let me know if you need further assistance.', Response) 
WHERE ID = '$ID'";

[wscreate]

NogDog;10897033 wrote:

You're going to kick yourself....

$query = "UPATE mytable 
SET Response=concat('Let me know if you need further assistance.', Response) 
WHERE ID = '$ID'";

Is it really that easy?

<tries it>

Why, yes it is.

Thanks for the quick reply, NogDog.