Search for value within BLOB column in MySQL
33,238
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, it's better to use a TEXT
field.
Related videos on Youtube
Author by
Zamblek
Updated on July 09, 2022Comments
-
Zamblek almost 2 years
How can I search inside Blob column in MySQL for some values ? and Is that possible ?
-
Zamblek over 13 yearsThanks a lot, plus I have to use BLOB not TEXT
-
zzapper almost 9 yearsJust to emphasize when you "Like" search a Blob the search is case sensitive so LIKE '%fred%' is different to LIKE '%Fred%' .
-
JBS almost 6 yearsWhy is it better to use TEXT? Is BLOB slower to interact with?