drawrof Posted June 23, 2007 Share Posted June 23, 2007 5.0.27-standard okay. i'm very new. but i've managed to created this simple search script that is running off of a database. it's based on the search engine script here with a few others. boolean searching. anyways, everything works okay. except when i search for the word "last". when i do that, it says it found no results. any ideas? Table structure for table songs Field Type Null Default title varchar(255) Yes link varchar(255) Yes Dumping data for table songs water from the same source tttt last things last tttt from water fff poop from poop sdfaf last things last yes last last s fast fast f fast last l list list Quote Link to comment https://forums.phpfreaks.com/topic/56818-database-will-not-find-certain-word/ Share on other sites More sharing options...
bubblegum.anarchy Posted June 23, 2007 Share Posted June 23, 2007 Post the search query. Quote Link to comment https://forums.phpfreaks.com/topic/56818-database-will-not-find-certain-word/#findComment-280725 Share on other sites More sharing options...
drawrof Posted June 23, 2007 Author Share Posted June 23, 2007 http://iheartadelie.org/test.php thanks. i can supply the php if necessary... perhaps it has something to do with that being in the stopword file? Quote Link to comment https://forums.phpfreaks.com/topic/56818-database-will-not-find-certain-word/#findComment-280730 Share on other sites More sharing options...
bubblegum.anarchy Posted June 23, 2007 Share Posted June 23, 2007 post the mysql code please... not the php the mysql code that is sent to the mysql server for processing. Quote Link to comment https://forums.phpfreaks.com/topic/56818-database-will-not-find-certain-word/#findComment-280735 Share on other sites More sharing options...
Wildbug Posted June 23, 2007 Share Posted June 23, 2007 It's a stopword. http://dev.mysql.com/doc/refman/5.1/en/fulltext-stopwords.html Quote Link to comment https://forums.phpfreaks.com/topic/56818-database-will-not-find-certain-word/#findComment-280835 Share on other sites More sharing options...
drawrof Posted June 23, 2007 Author Share Posted June 23, 2007 is there any way around this stopword list besides modifying the mysql install? Quote Link to comment https://forums.phpfreaks.com/topic/56818-database-will-not-find-certain-word/#findComment-280880 Share on other sites More sharing options...
Wildbug Posted June 23, 2007 Share Posted June 23, 2007 I don't think so, unless you, like, like LIKE. ...WHERE textcol LIKE '%last%'... Quote Link to comment https://forums.phpfreaks.com/topic/56818-database-will-not-find-certain-word/#findComment-280892 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.