How can I search inside Blob column in MySQL for some values ? and Is that possible ?
+1
A:
You should be able to search blobs like other text fields:
SELECT * FROM tablename WHERE blob_field_name LIKE '%value%'
One thing to notice is that search will be case-sensitive!
Anyway, if possible, better use a TEXT field.
zilverdistel
2010-09-19 18:26:06
Thanks a lot, plus I have to use BLOB not TEXT
D3VELOPER
2010-09-22 01:48:50