Hi

How would I go about updating the column "Country" with the data in the URL column.

ie: I want to select all records that have the .com.au in the URL column and add Australia to the column "Country" in those same records.

Same with .com.ca - Canada .com.it - Italy etc etc

Using Links SQL 2.10 on a MS SQL 7 Server.

Thanks

Regards

minesite

Do you mean something like:

UPDATE Table SET Country = 'Australia' WHERE URL LIKE '%.com.au'

?

Paul, this must rate as one of the quickest reply's.

I think it should do it, would it also grab the URL's that are

.com.au/index.html ? or just ones that have .com.au at the end ?

Thanks

Regards

minesite

To catch *.com.au/* try;

UPDATE Table SET Country = 'Australia' WHERE URL LIKE '%.com.au%'

Andy (mod)
andy@ultranerds.co.uk

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Thanks Andy, much appreciated. ( 2 mins )

Another quick one, is this relevant to our usage with Links SQL

---

Start transaction;



UPDATE Table SET Country = 'Australia' WHERE URL LIKE '%.com.au%'

Rollback work;

Commit work;

---

Regards

minesite

Thanks, All, for this thread. I'm learning more and more about mysql, and it's great.

------------------------------------------
dog tags