View Single Post
  #4  
Old 04-22-2002, 04:09 PM
stormgod
Discordant
 
Join Date: Apr 2002
Posts: 419
Default

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
Reply With Quote