Full text search with numbers

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
jraede
Forum Contributor
Posts: 254
Joined: Tue Feb 16, 2010 5:39 pm

Full text search with numbers

Post by jraede »

I have a 'meta' column, indexed as a FULL TEXT index, which stores all the information that I want to search. I guess I'm not exactly following how this works, because when I search things like "901", and there's an entry with the meta column "901 bar & grill 9-0 nine-o 90 thursday sports mexican american/traditional restaurant bar", that entry has a match score of 0. Same thing with "29", for the "29th Street Cafe". However, it seems to be working fine with just words. Why not with numbers? I just checked, and far less than 50% of the entries have either 901 or 29 in their meta columns, so it couldn't be that.

Thanks.
Post Reply