FULLTEXT searching - search engine
Posted: Fri Aug 30, 2002 6:38 pm
I've read an article on devshed about using the FULLTEXT search for searching large amounts of rows as opposed to using the "LIKE" method
most of the information I've found on fulltext clearly says that its a better method for doing search engine type searches....
couple questions/points....
I have a test database with 24 records/rows
I searched for the word "camera" which is present in 3 rows and it displayed perfectly
I searched for the world "film" which is present in 17 of the 24 rows and it returned 0 results
I imagine this is the 50% rule
how do you get around that? do you send a message back saying be more specific in your search?
do you do an if statement that if mysql_num_rows = 0 do the same search using the LIKE method?
and does using fulltext increase the table size? thanks all!
most of the information I've found on fulltext clearly says that its a better method for doing search engine type searches....
couple questions/points....
I have a test database with 24 records/rows
I searched for the word "camera" which is present in 3 rows and it displayed perfectly
I searched for the world "film" which is present in 17 of the 24 rows and it returned 0 results
I imagine this is the 50% rule
how do you get around that? do you send a message back saying be more specific in your search?
do you do an if statement that if mysql_num_rows = 0 do the same search using the LIKE method?
and does using fulltext increase the table size? thanks all!