php - How to perform MySQL "LIKE" query on a compressed field of blob type? -

i trying store large text in mysql field of blob type. compress large text compress($large_text) , store in mysql - insert table set large_text = compress($large_text)

if want select large_text query - select uncompress(large_text) table

what need is, want like query on compressed field like, select * table large_text 'abc'

i can't able since large_text compressed blob.

how like query on compressed blob? hope clear question.

any appreciated.

it can directly searched without uncompress :

select * table large_text '%abc%'  

if want search multiple words can use underscore between word because spaces converted underscore :

select * table large_text '%abc_xyz%'