[SOLVED] Partial text searches with FULLTEXT?
Posted: Tue Nov 28, 2006 6:14 am
I've made a pretty reliable search script for a client using Fulltext on MySQL 4.1 which searches on practically all the columns in all the tables in his database etc etc, but he's just come back with a complaint::roll:
How can I incorporate something like a "like = '$word%'" search without wrecking my Fulltext searching capabilities? I don't want to have to undo my previous hard work!!!
Now back in the day when I used "like" for very very simple searches this was not a problem, but in my limited understanding, fulltext is not designed to work that way. I've read up on the "*" operator but it doesn't seem to work for me on the above example. Is this limited to MySQL 5?Can we not just search the whole directory based on the characters entered as above rather than whole words? eg "Rowenta" returns results but not "rowe".
How can I incorporate something like a "like = '$word%'" search without wrecking my Fulltext searching capabilities? I don't want to have to undo my previous hard work!!!