Andy Booth Posted January 12, 2007 Share Posted January 12, 2007 Having a little trouble with my full-text searching of my MySQL database. I have a table of game names, with game id's and platforms. Anyways, im using a query.."SELECT games.game_name, games.game_id, games.game_console FROM games WHERE MATCH(game_name) AGAINST ('".$search."') AND (games.game_console = '".$consoles."') ORDER BY game_name ASC"It works fine, apart from when I search for a game with numbers at the start, such as "007 Racing" will return no results. Does my method not support numbers? Any help much appreciated :) Quote Link to comment Share on other sites More sharing options...
fenway Posted January 12, 2007 Share Posted January 12, 2007 Actually, it's supposed to be full_text_ search, so it throws away numbers, or uses them as stop words, I don't remember. Quote Link to comment Share on other sites More sharing options...
Andy Booth Posted January 13, 2007 Author Share Posted January 13, 2007 Any way I can get around this? Quote Link to comment Share on other sites More sharing options...
fenway Posted January 13, 2007 Share Posted January 13, 2007 Not really, other than writing a custom index or using one of various fulltext addons. 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.