Code:
SELECT STATE.state_id, STRING.value
FROM Arcadia.dbo.StateResource STATE, Arcadia.dbo.StringResource STRING
where STRING.code=STATE.text_id and STRING.value like '%Luna%'
Code:
SELECT STATE.state_id, STRING.value
FROM Arcadia.dbo.StateResource STATE, Arcadia.dbo.StringResource STRING
where STRING.code=STATE.text_id and STRING.value like '%SearchTerm%'
Modify this Statement and you can use it to search for items, skills etc