Sql

[RiiOT]

Hello guys i was wondering of theirs a sql code for this i am looking for.

 

Example theirs a item that needs item index "19" is their a replace sql code for this?

 

like to replace item index 19 in t_npc under a_item_1 (only) and it replaces all 19 with example 10?

 

Thanks.

[Nymphetamine]

UPDATE t_npc SET a_item_1 = 19 WHERE a_item_1 = 19

 

Or

 

UPDATE t_npc SET a_item_1 = 19 WHERE a_index = 19

 

That should work

[RiiOT]

UPDATE t_npc SET a_item_1 = 19 WHERE a_item_1 = 19

 

Or

 

UPDATE t_npc SET a_item_1 = 19 WHERE a_index = 19

 

That should work

UPDATE t_npc SET a_item_1 = 19 WHERE a_item_1 = 19

 

Has Worked 100% Thanks

[xMeowx3]

Hi.

As you got your answer, and your problem is solved, I am gonna move that topic to Solved section and mark it as solved.

 

Thanks,

 

-LCKB Staff