innitboy Posted November 4, 2006 Share Posted November 4, 2006 I would like to use match against in a query but its not returning any resultsthe only data i have in the column is 3,2,1I want to match all the records that are 3,doesnt seem to return any results,does match against work with numerical searches?cheers Quote Link to comment Share on other sites More sharing options...
.josh Posted November 4, 2006 Share Posted November 4, 2006 I'm not sure but i think the default minimum search length is like 4 characters or something. this can be changed, if you have that kind of access: http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.htmlbut that's just a guess. i'm moving this to the sql forums. Quote Link to comment Share on other sites More sharing options...
fenway Posted November 4, 2006 Share Posted November 4, 2006 Yes, it does treat numbers "properly", but you can't change the min. length without recompiling the server. Quote Link to comment Share on other sites More sharing options...
.josh Posted November 5, 2006 Share Posted November 5, 2006 If you don't have access to do that, I suppose you can do a workaround like so:select * from table where field1 = 3 or field2 = 3 or field3 = 3 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.