[SQL] multiple sql update w/ major time issues

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

[SQL] Table Sorting and Limit Question

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

Re: [SQL] Table Sorting and Limit Question

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

[SQL] how to do a find and replace

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

[SQL] how to do a find and replace

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)--

Re: [SQL] how to do a find and replace

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