You have chosen to sponsor your bid up to a maximum amount of .
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