how to do reverse fulltext search in MySQL?
Posted
by Shore
on Stack Overflow
See other posts from Stack Overflow
or by Shore
Published on 2009-07-01T23:16:34Z
Indexed on
2010/05/20
22:20 UTC
Read the original article
Hit count: 224
Filed under:
mysql
|full-text-search
By default it's like this:
select * from main_table where match(col1,col2) against('search_item');
but what I want to fetch is the reverse,
say,I've restored all the search_item(1000 records,for example),
and I want to see which of them matches a specified row in main_table.
Is that doable?
© Stack Overflow or respective owner
