adding information to existing existing data

I have a table (inventory) with field (item_no) and would like to add some
information to the end of the existing data in the item_no field. In
example, item_no = 1234-01 would now be 1234-01(wp). I'm not quite sure
where to even start and I've never done anything like this and I have
several hundred items to update.


A

Auddog wrote:
> I have a table (inventory) with field (item_no) and would like to add some
> information to the end of the existing data in the item_no field. In
> example, item_no = 1234-01 would now be 1234-01(wp). I'm not quite sure
> where to even start and I've never done anything like this and I have
> several hundred items to update.

UPDATE table SET item_no=concat(item_no,'(wp)') WHERE item_no='1234-01';

--

//Aho

On Fri, 11 Jan 2008 20:23:35 +0100, J.O. Aho wrote:
> Auddog wrote:
>> I have a table (inventory) with field (item_no) and would like to add some
>> information to the end of the existing data in the item_no field. In
>> example, item_no = 1234-01 would now be 1234-01(wp). I'm not quite sure
>> where to even start and I've never done anything like this and I have
>> several hundred items to update.
>
> UPDATE table SET item_no=concat(item_no,'(wp)') WHERE item_no='1234-01';
>

Not that the WHERE clause doesn't have to be there, or can be based on
any other selection criteria you like, like a LIKE for part numbers
(WHERE item_no LIKE '123%') or even on a non-item_no column (maybe a
manufacturer), or omitted altogether.

--
45. I will make sure I have a clear understanding of who is responsible for
what in my organization. For example, if my general screws up I will not
draw my weapon, point it at him, say "And here is the price for failure,"
then suddenly turn and kill some random underling. --Evil Overlord List