here would be a simple request to get the name of and item you already got the ID :
first part getting the ID
SELECT * from items where raw_data LIKE '%" & Texttosearch & "%';
this should find the text to search and fill your recordset
but it will be case sensitive
ie it will Jagged Blade of War if you search for "agged" but not "AgGed"
then you get the id from the id field
SELECT mid(raw_data,1,35) from items where id = '" & testid & "' ;
this will get you the name of a specific item id
Hope this helps
Hybrid Mode
