I have 3 sentences in table. These are the sentences.
Spatio-temporal tracking and phylodynamics prm. These are prM based values. All MR values are greater intensity than PRM vales. Values specified are equal to PRm values and PRM-lacZ.
If user specifies the query like this: prm* i want to retrieve all these rows.
I tried the query like this:
select data from allarticles where MATCH sentences AGAINST('prm*' IN BOOLEAN MODE);
The problem with the above query is not fetching the rows properly.
How can i get all the rows when user specifies "prm*"???
'*' indicates all the variations of prm!
How can i get all variations of prm??