XF 2.3 Old Import database table Data Issue

[puertoblack2003]

I need a sample database query line

( UPDATE tablename SET settings = REPLACE(value,' sample',' sample2'); )

something similar to this. I need to change from "0" in user_id column to actual username id example "14326". The problem with this is columns. it needs to pull column from username to user_id to change from "0" to actual Id number. Is there a better solution?