I need a sample database query line
SQL:
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?
Continue reading...
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?
Continue reading...