UBB.threads PHP Forum Software Community Forums Resources and Customizing Admin Zone SQL Script Help to Change a String

I have defined Custom Field 1 to hold the URL for an external database record. The database is powered by ColdFusion and we're changing the server it is hosted on. The data stored in USER_EXTRA_FIELD_1 is either blank or has a fully qualified URL in the format of http://domain_name.org/updtform1.cfm?id=375

The number at the end of the URL is a unique record pointer and can be anything from 1 to 999.

What I would like to do is run a SQL script that will allow me to strip out everything but the number at the end of the URL and save it back to USER_EXTRA_FIELD_1 as just the number in text form. If USER_EXTRA_FIELD_1 was blank, it just ignores the record. That way I can concatenate the new URL and the stored number without having to store the entire new URL.

Can anyone help me with the SQL script?

assumes the same thing is up front for every one and that the only difference is AFTER the = sign

Thanks! That is correct on the assumption too.

Though if that site allows users from a www and a non-www domain, you may end up with some users pasting the other url

actually I'm the one who loads that field for everyone and I know better

It is displayed as a hot link that is only visible by admins and the specific user logged in.

This just saved me a lot of editing.