Peruttu

Simple SQL query needed - immediately

Our forum upgrade put the wrong name in the username of the new forum and its causing problems! We have a site we were supposed to launch last night and are quite desperate to fix this so we can launch (the site has been down for 3 days).

So we need to search for a match between [url removed, login to view] with [url removed, login to view] and replace [url removed, login to view] with the corresponding [url removed, login to view], and also make the value of [url removed, login to view] all lowercase and replace the phpbb_users.username_clean. There are about 1200 entries to update.

CURRENT

smf_members

memberName Jennyb

realName Jenny

phpbb_users

username Jenny

username_clean jenny (note lower case)

DESIRED

smf_members (no change)

memberName Jennyb

realname Jenny

phpbb_users (both changed)

username Jennyb

username_clean jennyb (username made lower case)

Time is of the essence.. please only bid if you can provide the SQL query immediately.

Taidot: SQL

Näytä lisää: simple forum replace sql, smf_members, problems with match, n query, match problems, sql, SQL Query, sql c, simple query, immediately, last days sql, fix query, desperate, desperate need, needed upgrade, change search query, fix match, query query, sql query last days, last days query, sql site, case note, immediately replace, search query, simple sql

About the Employer:
( 0 reviews ) Buckhorn, Canada

Projektin tunnus: #453650

1 freelanceria on tarjonnut keskimäärin 50 $ tähän työhön

leechdraw

i'll do it fast. contact me

50 $ USD 1 päivässä
(0 arvostelua)
0.0