what i need is that
a title having
“War in Afganistan in 2010”
“Afganistan War in 2010”
“WarAfganistan in 2010”
now i need to get all the title having war and Afganistan as shown above so for this we have written a query
select e2.title from A e2 where match(e2.title) against (‘+War* +Afghanistan*’ IN BOOLEAN MODE);
which give
“War in Afganistan in 2010”
“Afganistan War in 2010”
but not getting
“WarAfganistan in 2010”
reason is that WarAfganistan is one word how can i get this title also ?