Forums WoW Modding Support Archives Azerothcore Discord Archives [DiscordArchive] I'm trying to create a select statement that returns every `entry` in the `item_template` table, wit

[DiscordArchive] I'm trying to create a select statement that returns every `entry` in the `item_template` table, wit

[DiscordArchive] I'm trying to create a select statement that returns every `entry` in the `item_template` table, wit

rektbyfaith
Administrator
0
09-18-2021, 12:55 PM
#1
Archived author: ReynoldsCahoon • Posted: 2021-09-18T12:55:11.523000+00:00
Original source

I'm trying to create a select statement that returns every `entry` in the `item_template` table, with each `spellid_1, spellid_2, spellid_3, spellid_4, spellid_5` separated into it's own row under a unified `spellid` column. Anyone have any idea how I'd accomplish that?
rektbyfaith
09-18-2021, 12:55 PM #1

Archived author: ReynoldsCahoon • Posted: 2021-09-18T12:55:11.523000+00:00
Original source

I'm trying to create a select statement that returns every `entry` in the `item_template` table, with each `spellid_1, spellid_2, spellid_3, spellid_4, spellid_5` separated into it's own row under a unified `spellid` column. Anyone have any idea how I'd accomplish that?

Recently Browsing
 1 Guest(s)
Recently Browsing
 1 Guest(s)