How do you Search By Item Name in a blob?

[mByte]

I am fiddling around with making the Admin C# and working with blobs are nuts.

I can populate my fields and things of that nature and search the ID field but for the life of me I can not figure out how you search the blob.

[stormgod]

SELECT id from items where LCase(mid(raw_data,1,35)) LIKE '%item_you_want%';


1 35 are the decimal position of beginning and ending of the name , at least it was inm 3.3.1 , else just check using mysql dump or look into the eq_packet_struct file

[mByte]

well thats alot easier then what i ended up doing heh