Re: Rating results after relevance. Difficult problem

NOT ISNULL? Like where rating NOT ISNULL? does not work though. The thing is that this values are not NULL, they are 0 so maybe I did get you wrong. We do create an extra value called result (... AS result) this is sometimes 0. I tryed: WHERE result != 0, but mysql does not know about result. Andy "David Robley" <robleyd@paradise.net.nz> schrieb im Newsbeitrag news:MPG.1744fa7cc4625a3098971b@news.php.net... > In article <20020509065440.5713.qmail@pb1.pair.com>, news.letters@gmx.de > says... > > wow! Sven's idea works just great! Didn't try it on the 2000 user db though. > > But I looks much clearer than creating temp tables and doing all the math on > > 1000 users in php. > > > > So I was just wondering if there is a better way to get rid of the 0 results > > than I have found. > > First I did try to add > > where results != 0 > > but the db does not know about the results row > > Then I did put the whole if statement ( if (news.text_short like '%test%', > > 50, 0) + if (user.name > > > like '%woodoo%', 50, 0) > > into the where clause and this works. Just not that elegant. > > Minor prob, but maybe someone knows a better way. > > > > > > Thanx for the great help! > > > > Andy > > This is mysql? Try NOT ISNULL to exclude null values. > > -- > David Robley > Temporary Kiwi! > > Quod subigo farinam