Hi,
For example lets consider i have word like this:cell
I have some text that is stored in table.
These are few sentences.
TRAP also regulates translation of trpE by promoting formation of an cell.
In addition initiation of pabA, trpP and ycbK by directly blocking cells.
I tried giving query like this:
"select * from table1 where sentences rlike'[[:<:]]cell*[[:>:]]'";
But it is not giving correct results!!!
I tried with full text searching also but i didn't get results!
How should i give query such that it gets all occurances of cell?
With regards
Vanitha