I have a table test with field column1. whitespace analyzer on column1 (showing two rows in table test)
|this is first row|
|this is row first|
when I query,
select * from table where match(column1, 'this is first'). it gives me 2 rows instead of 1. Any idea where I am doing it wrong or is there a way to get a single row in such a case (this is first row only)
Note: Due to some memory limitations I cannot apply keyword analyzer here.