Re: Help With An UPDATE Query Please
| From: | Ignatius Reilly | Date: | Tue, 10 Feb 2004 13:27:05 +0000 |
| Subject: | Re: Help With An UPDATE Query Please | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-32887@lists.php.net to get a copy of this message | ||
UPDATE table
SET column = CONCAT(
MID( column, 2, LENGTH( column ) - 1 ),
MID( column, 1, 1 )
)
WHERE column LIKE 'M%'
HTH
Ignatius
_________________________
----- Original Message -----
From: "Shaun" <shaun@mania.plus.com>
To: <php-db@lists.php.net>
Sent: Tuesday, February 10, 2004 14:15
Subject: [PHP-DB] Help With An UPDATE Query Please
> Hi,
>
> How can I update a column where the first letter begins with 'M' and
adjust
> it so that column ends with 'M' instead. So something like 'UPDATE table
SET
> column = 'xxxM' WHERE column = 'Mxxx'. I hope this explains what I am
trying
> to achieve!
>
> Thanks
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>