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 Link to comment https://forums.phpfreaks.com/topic/26158-mysql-full-text-search-work-with-numbers/ 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. Link to comment https://forums.phpfreaks.com/topic/26158-mysql-full-text-search-work-with-numbers/#findComment-119634 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. Link to comment https://forums.phpfreaks.com/topic/26158-mysql-full-text-search-work-with-numbers/#findComment-119683 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 Link to comment https://forums.phpfreaks.com/topic/26158-mysql-full-text-search-work-with-numbers/#findComment-119870 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.