i am using this statment
select * from o_articles where catid=‘1’ and forid=‘2’ and ( article
like(’%big house%’) OR article like(’%big%’) OR article like(’%house%’)
and status=‘1’ OR title like(’%big house%’) ) order by ‘article’ asc
limit 0,10
there are two rows matching this , one having at its very begining the
word “big house” another have just the word “big”
i am trying to get them ordered by the NEAREST MATCHING comes first,
but it did not work, i change the Order by clause to all possible
values it did not work mad:
it always get orderd by the catid as it is the primary key,
the fields article is full text and title is varchar
if you can help i will be so thankful to you,
thanks