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 :) Link to comment https://forums.phpfreaks.com/topic/33907-mysql-full-text-searching-with-numbers/ 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. Link to comment https://forums.phpfreaks.com/topic/33907-mysql-full-text-searching-with-numbers/#findComment-159554 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? Link to comment https://forums.phpfreaks.com/topic/33907-mysql-full-text-searching-with-numbers/#findComment-159889 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. Link to comment https://forums.phpfreaks.com/topic/33907-mysql-full-text-searching-with-numbers/#findComment-159965 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.