I have a simple fulltext search query:

```
SELECT *, MATCH(col1,col2,col3) AGAINST ('keywords' IN BOOLEAN MODE) AS relev FROM table1 ORDER BY relev DESC

```

Which technically works but it also returns results with a relevance of 0.

I tried to use: 

```
SELECT *, MATCH(col1,col2,col3) AGAINST ('keywords' IN BOOLEAN MODE) AS relev FROM table1 WHERE relev > 0 ORDER BY relev DESC

```

but that tells me that `relev` is an invalid column name.

Is there any way to exclude results with a `relev` of 0 without having to use `MATCH(..) AGAINST(..)` again within the `WHERE` clause? Doesn't doing that basically repeat the fulltext search again and take twice as much time?