Adam, this will not work with fulltext. Non-alphanumeric characters will be ignored and treated as spaces. There remain some chunks like 10 2 4 and these are too short (less than 3 characters) and will never be indexed.
Sorry, no way. Except for an ugly hack. You may try to replace dots between numbers in your data and in your query with something else. But your client application has to take care of this. Let's have a look at an example abusing character with ASCII 254 decimal: > create table ft ( r1 varchar(255), fulltext ftindex (r1)) type=MyISAM; > insert into ft values('some data 10þ4þ6'),('today 2003þ3þ4'),('on mysql version 4þ0þ12'); > select * from ft where match(r1) against('10þ4þ6'); yields: *************************** 1. row *************************** r1: some data 10þ4þ6 1 row in set (0.01 sec) and: > select * from ft where match(r1) against('4þ0þ*' in boolean mode); yields: *************************** 1. row *************************** r1: on mysql version 4þ0þ12 1 row in set (0.00 sec) and its up to your client application to convert those 'þ' char(FE) back to '.' happy hacking, Thomas Spahni On Thu, 3 Apr 2003, Adam Randall wrote: > Since no one responded to this message at all, I'm sending it again. > > I have a support system set up where people can search for various > things using a fulltext index. The problem that I am having, though, > is that I cannot seem to figure out how to get search results for > values like "10.2.4" or "6.0.4". This is with MySQL 4.0.12, with the > minimum word length of 3 (so we can search for PHP, IIS, etc). > > Here are some examples of how the search is being performed: > > select id,topic from articles where match(topic,summary,description) > against ('10.2.4'); > (no results) > > select id,topic from articles where match(topic,summary,description) > against ('"10.2.4"' in boolean mode); > (no results) > > select id,topic from articles where topic like '%10.2.4%' or summary > like '%10.2.4%' or description like '%10.2.4%'; > (3 rows found) > > I don't really want to do the last search because it's the slowest, > and searching the most data un-indexed. > > Anyway, if anyone has any advice, I would appreciate it. > > Adam. > > ----------------------------------------------------------------------- > Adam Randall http://www.xaren.net/ > [EMAIL PROTECTED] http://nt.xaren.net/ > [EMAIL PROTECTED] AIM/iChat: blitz574 > > "Macintosh users are a special case. They care passionately about the > Mac OS and would rewire their own bodies to run on Mac OS X if such a > thing were possible." -- Peter H. Lewis > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]