I used:
update media_instance set location=replace(location,'v.','')
where location like '%/0/v.%'
and that did work-
thank you very much.
it seems to me that the replace function is the same as translate()- no?
On 17-Nov-05, at 3:55 PM, Bricklen Anderson wr
ROM myTable
WHERE location = '%/0/v.%'
I'm just confused about how I should write code to update the selected
items to remove the 'v.'
Would I use substring? An example would be much appreciated.
thank you
Dawn
---(end of broadcast)--
ble to do a
SELECT * FROM myTable
WHERE location = '%/0/v.%'
I'm just confused about how I should write code to update the selected
items to remove the 'v.'
Would I use substring? An example would be much appreciated.
thank you
Dawn
---(end
ffset into the query would contain the id I'm
interested in.
Dawn Hollingsworth
Principal Engineer
AirDefense, Inc.
On Thu, 2002-08-08 at 21:42, Ludwig Lim wrote:
>
> --- Dawn Hollingsworth <[EMAIL PROTECTED]> wrote:
> >
> >
> > Currently we have a tab
sort the table by date but
pull out the hundred row set that contains id say...542 for example.
What would be the best way to do this taking into account this table is
several hundred thousand rows?
Dawn Hollingsworth
Principal Engineer
AirDefense, Inc.
---(end of
I have a sql update statement that is dealing with hundreds of
thousands of records. It takes hours and hours to complete (if it
does complete and not take down the server). Here is how I have it
right now:
update aud_member_ext_attributes b
set EXTVALUE217 =
(select a.MTD
from
