All Questions
Tagged with php full-text-search
4 questions
1
vote
2
answers
253
views
Fulltext searching on shared hosting - 2000 Entires with around 500 words each
I'm fairly new to db administration and would appreciate some help. I want to host a site which requires full text search on around 2000 items, each with around 500 words each. I need this to be ...
- 113
2
votes
2
answers
10k
views
MYSQL matching one column to another in a different table via a FULLTEXT index
I current have two different tables.
The first table has a list of titles and IDs associated to these titles; the second table is a list of random heading.
What I would like to know is if there is a ...
- 149
10
votes
1
answer
2k
views
Calculate MATCH() AGAINST() scores from UNIFIED QUERY not FOR EACH TABLE
I am trying to have a score for entire section of SELECT statements
SELECT *,MATCH(`result`) AGAINST('keyword') as `score` FROM `table1` WHERE MATCH(`result`) AGAINST('keyword')
UNION
SELECT *,MATCH(`...
- 201
0
votes
1
answer
74
views
Searching through lots of applications
Google search has instant search feature. While you are typing, it finds the pages. Apple.com search box. StackExchange ask question part finds similar questions while you are typing question title.
...
- 143