Full-Text search in encoded table

[yigit dalkiran]

hi,

i have a table containing encoded content. i try to search like this;

SELECT * FROM `mytable` WHERE MATCH (column) AGAINST (Encode('keyword','pass')) IN BOOLEAN MODE);

and also tried

SELECT * FROM `mytable` WHERE MATCH (Decode(column,'pass')) AGAINST ('keyword' IN BOOLEAN MODE);

but any of them worked! any ides please? thank you