Wonder if you can help me, I need an update statment where I need to take the number out from (?unid=332)a URL and place it into the BOOK_ID column
So this URL appears in the BOOK_URL field, I need to take the number out from ?unid=332
and place it into the BOOK_ID field
so in this case the number would be 332, please note the number could be of any length, but it will always be a number
The table name is called Book, it has to be an update statement as well.