ENXF NET
Administrator
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P.S Member
S.V.I.P Member
V.I.P Member
Collaborate
Registered
- Joined
- Nov 13, 2018
- Messages
- 24,821
- Points
- 823
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...