Help with QUERY I don't know where to start[TrinityCore Database Structure]

[slater2k]

Hello I am in need of a MySQL [SQL] specialist's help

I need to set the buyprice of all items with a certain vendor id

To do this I need to select all item ids from the npc_vendor table where entry='vendorid'

than with these items that are selected I would need to select all those item entry ids from item_template than set where item entry id buyprice='wtv' since there are a lot of vendors I want to adjust prices on with just a click but if I were to do it manually there would be thousands of items I would have to go through I think this query would be possible but I am not good enough in SQL to write this query

Thanks for reading and future help

thanks for future help

[Rock Lee]

SELECT *
FROM npc_vendor
WHERE entry = "vendorid" OR entry = "vendorid2"

[Dynashock]

UPDATE item_template SET buyprice = 'price' WHERE entry IN (SELECT item FROM npc_vendor WHERE entry = 'vendorid')

If you want to run it on multiple vendors at once use this query instead:

UPDATE item_template SET buyprice = 'price' WHERE entry IN (SELECT item FROM npc_vendor WHERE entry in (vendorid1, vendorid2, vendorid3 and so on))

[slater2k]

UPDATE item_template SET buyprice = 'price' WHERE entry IN (SELECT item FROM npc_vendor WHERE entry = 'vendorid')

If you want to run it on multiple vendors at once use this query instead:

UPDATE item_template SET buyprice = 'price' WHERE entry IN (SELECT item FROM npc_vendor WHERE entry in (vendorid1, vendorid2, vendorid3 and so on))

Thank you greatly appreciated

[slater2k]

Ok now I have another question how would I use this query and only update the buyprice of the entry items if the itemlevel field is less than or equal to a certain number?

[marcelo_20xx]

UPDATE item_template SET buyprice = 'price' WHERE entry IN (SELECT item FROM npc_vendor WHERE entry = 'vendorid' ) AND itemlevel <='number';

UPDATE item_template SET buyprice = 'price' WHERE entry IN (SELECT item FROM npc_vendor WHERE entry in (vendorid1, vendorid2, vendorid3 and so on)) AND itemlevel <='number';

[slater2k]

Aha thats how you do it with the AND syntax thank you