mysql work - repost

CLOSED
Bids
14
Avg Bid (USD)
$17
Project Budget (USD)
$10 - $15

Project Description:
Need a mysql query.

In dbase, have records with field names field1 and field2.

Should search for records that contain a comma in field1, and if they do, copy the text from the end of the string in field1 up to the last comma (but not including comma) into field2.

So if field1 is 1234,5678,9101

field2 should be 9101

Skills required:
MySQL
Hire dialsl
Project posted by:
dialsl United Kingdom
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 15
in 0 days
$ 19
in 0 days
$ 10
in 1 days
$ 20
in 1 days
$ 10
in 0 days
Hire liemvo
$ 14
in 0 days
Hire revzz
$ 17
in 3 days
$ 10
in 1 days
Hire kuldippatel412
$ 25
in 3 days
Hire iovumarcel
$ 15
in 1 days