bcamp1973 Posted March 10, 2007 Share Posted March 10, 2007 I'm using FULLTEXT indexes and MATCH() AGAINST() to do searches on first and last names and email addresses. i'm noticing that i get no results for names like Tim, Joe etc. But if the name is 4 characters or more i'll get a match. I take it FULLTEXT is limited to 4 or more characters? Are there any ways around this? Quote Link to comment Share on other sites More sharing options...
fenway Posted March 11, 2007 Share Posted March 11, 2007 There is a min. word length, I know one of the options is available in the my.cnf file, the other requires a server recompile. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.