here's what I got so far
Code:
select * from items
where `Name` like 'FABLED%'
or `Name` in (
select replace(`Name`, 'FABLED ', '') as fable_item
from items
where `Name` like 'FABLED%'
);
but now im stuck trying to manipulate the items. I think I took a wrong approach here... any help?