Old Import database table Data Issue

I need a sample database query line
SQL:

( 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?



Читать далее...