[Edgar1898]

Simple analogy follows:

create a simple table and fill it with our test data like so:

CREATE TABLE `item_names` (`prefix` VARCHAR (32));
ALTER TABLE `item_names` ADD `model` VARCHAR(32);
ALTER TABLE `item_names` ADD `suffix` VARCHAR(32);
INSERT INTO item_names (prefix, model, suffix) VALUES ('Corroded', NULL, NULL);
INSERT INTO item_names (prefix, model, suffix) VALUES ('Fabled', NULL, NULL);
INSERT INTO item_names (prefix, model, suffix) VALUES ('Prestine', NULL, NULL);
INSERT INTO item_names (prefix, model, suffix) VALUES ('Moldy', NULL, NULL);
INSERT INTO item_names (prefix, model, suffix) VALUES ('Torn', NULL, NULL);
INSERT INTO item_names (prefix, model, suffix) VALUES ('Worn', NULL, NULL);
INSERT INTO item_names (prefix, model, suffix) VALUES ('Dull', NULL, NULL);
INSERT INTO item_names (prefix, model, suffix) VALUES ('Eradicating', NULL, NULL);
INSERT INTO item_names (prefix, model, suffix) VALUES (NULL, 'Breastplate', NULL);
INSERT INTO item_names (prefix, model, suffix) VALUES (NULL, 'Earing', NULL);
INSERT INTO item_names (prefix, model, suffix) VALUES (NULL, 'Sword', NULL);
INSERT INTO item_names (prefix, model, suffix) VALUES (NULL, 'Staff ', NULL);
INSERT INTO item_names (prefix, model, suffix) VALUES (NULL, 'Tunic Dagger', NULL);
INSERT INTO item_names (prefix, model, suffix) VALUES (NULL, NULL, 'of Vindication');
INSERT INTO item_names (prefix, model, suffix) VALUES (NULL, NULL, 'of the Unliving');
INSERT INTO item_names (prefix, model, suffix) VALUES (NULL, NULL, 'of the Lion');

then run the select query to get all the item names:

select concat(a.prefix,' ',b.model, ' ', c.suffix) from item_names a, item_names b, item_names c where length(concat(a.prefix,' ',b.model, ' ', c.suffix))>1 group by a.prefix,b.model,c.suffix;

The 120 results of the above command are:

• Corroded Breastplate of the Lion
  Corroded Breastplate of the Unliving
  Corroded Breastplate of Vindication
  Corroded Earing of the Lion
  Corroded Earing of the Unliving
  Corroded Earing of Vindication
  Corroded Staff of the Lion
  Corroded Staff of the Unliving
  Corroded Staff of Vindication
  Corroded Sword of the Lion
  Corroded Sword of the Unliving
  Corroded Sword of Vindication
  Corroded Tunic Dagger of the Lion
  Corroded Tunic Dagger of the Unliving
  Corroded Tunic Dagger of Vindication
  Dull Breastplate of the Lion
  Dull Breastplate of the Unliving
  Dull Breastplate of Vindication
  Dull Earing of the Lion
  Dull Earing of the Unliving
  Dull Earing of Vindication
  Dull Staff of the Lion
  Dull Staff of the Unliving
  Dull Staff of Vindication
  Dull Sword of the Lion
  Dull Sword of the Unliving
  Dull Sword of Vindication
  Dull Tunic Dagger of the Lion
  Dull Tunic Dagger of the Unliving
  Dull Tunic Dagger of Vindication
  Eradicating Breastplate of the Lion
  Eradicating Breastplate of the Unliving
  Eradicating Breastplate of Vindication
  Eradicating Earing of the Lion
  Eradicating Earing of the Unliving
  Eradicating Earing of Vindication
  Eradicating Staff of the Lion
  Eradicating Staff of the Unliving
  Eradicating Staff of Vindication
  Eradicating Sword of the Lion
  Eradicating Sword of the Unliving
  Eradicating Sword of Vindication
  Eradicating Tunic Dagger of the Lion
  Eradicating Tunic Dagger of the Unliving
  Eradicating Tunic Dagger of Vindication
  Fabled Breastplate of the Lion
  Fabled Breastplate of the Unliving
  Fabled Breastplate of Vindication
  Fabled Earing of the Lion
  Fabled Earing of the Unliving
  Fabled Earing of Vindication
  Fabled Staff of the Lion
  Fabled Staff of the Unliving
  Fabled Staff of Vindication
  Fabled Sword of the Lion
  Fabled Sword of the Unliving
  Fabled Sword of Vindication
  Fabled Tunic Dagger of the Lion
  Fabled Tunic Dagger of the Unliving
  Fabled Tunic Dagger of Vindication
  Moldy Breastplate of the Lion
  Moldy Breastplate of the Unliving
  Moldy Breastplate of Vindication
  Moldy Earing of the Lion
  Moldy Earing of the Unliving
  Moldy Earing of Vindication
  Moldy Staff of the Lion
  Moldy Staff of the Unliving
  Moldy Staff of Vindication
  Moldy Sword of the Lion
  Moldy Sword of the Unliving
  Moldy Sword of Vindication
  Moldy Tunic Dagger of the Lion
  Moldy Tunic Dagger of the Unliving
  Moldy Tunic Dagger of Vindication
  Prestine Breastplate of the Lion
  Prestine Breastplate of the Unliving
  Prestine Breastplate of Vindication
  Prestine Earing of the Lion
  Prestine Earing of the Unliving
  Prestine Earing of Vindication
  Prestine Staff of the Lion
  Prestine Staff of the Unliving
  Prestine Staff of Vindication
  Prestine Sword of the Lion
  Prestine Sword of the Unliving
  Prestine Sword of Vindication
  Prestine Tunic Dagger of the Lion
  Prestine Tunic Dagger of the Unliving
  Prestine Tunic Dagger of Vindication
  Torn Breastplate of the Lion
  Torn Breastplate of the Unliving
  Torn Breastplate of Vindication
  Torn Earing of the Lion
  Torn Earing of the Unliving
  Torn Earing of Vindication
  Torn Staff of the Lion
  Torn Staff of the Unliving
  Torn Staff of Vindication
  Torn Sword of the Lion
  Torn Sword of the Unliving
  Torn Sword of Vindication
  Torn Tunic Dagger of the Lion
  Torn Tunic Dagger of the Unliving
  Torn Tunic Dagger of Vindication
  Worn Breastplate of the Lion
  Worn Breastplate of the Unliving
  Worn Breastplate of Vindication
  Worn Earing of the Lion
  Worn Earing of the Unliving
  Worn Earing of Vindication
  Worn Staff of the Lion
  Worn Staff of the Unliving
  Worn Staff of Vindication
  Worn Sword of the Lion
  Worn Sword of the Unliving
  Worn Sword of Vindication
  Worn Tunic Dagger of the Lion
  Worn Tunic Dagger of the Unliving
  Worn Tunic Dagger of Vindication

Note that this is just a simple example, but if you use your imagination, you could create items using this process. It would take a lot of work because you have a lot more fields to work with but it would work...