Help Build a Query

How can i build a query to change "CanRepair" column, i can build that query for spcific ID, but how can i make it for spcific degree & type for example

type: HEAVY
degree: 01


another example

type: EARRING
degree: 09




thanks in advance.

USE SRO_VT_SHARD
set CanRepair = 0 where in (select ID from _refobjcommon where Codename128 like '%09%EARRING%')

I used the db's long time ago, im not sure about the earrings' codename... but you can figoure it out easily how it works...
NS

Quote:

Originally Posted by NagySandor96 USE SRO_VT_SHARD set CanRepair = 0 where in (select ID from _refobjcommon where Codename128 like '%09%EARRING%') I used the db's long time ago, im not sure about the earrings' codename... but you can figoure it out easily how it works... NS

That query is wrong on so many levels I can't even count it.

UPDATE _RefObjCommon SET CanRepair = 0 WHERE CodeName128 LIKE 'ITEM_%_%_HEAVY_05_%_A_RARE'

(This will do it for CH/EU, Male + Female, Heavy Armor / Armor, 5th degree, ALL types of clothes, SOS)

% = anything

Use the example above and just build for whatever you need. I strongly advise you to "select" first and then "update" to prevent affecting rows you don't want to. Have fun.

Quote:

Originally Posted by JohnDornel^ That query is wrong on so many levels I can't even count it. UPDATE _RefObjCommon SET CanRepair = 0 WHERE CodeName128 LIKE 'ITEM_%_%_HEAVY_05_%_A_RARE' (This will do it for CH/EU, Male + Female, Heavy Armor / Armor, 5th degree, ALL types of clothes, SOS) % = anything Use the example above and just build for whatever you need. I strongly advise you to "select" first and then "update" to prevent affecting rows you don't want to. Have fun.  Spoiler https://www.w3schools.com/sql/sql_wildcards.asp

thanks alot, i really appreciate it, i think what u just gave me, will help me alot in manyways.


#topic close please.

sure, i was wrong...

Quote:

Originally Posted by NagySandor96 sure, i was wrong...

i didn't try urs actually, but i think it would work too, thanks for ur post.