My made-up query invention

Is it possible to use the MATCH () AGAINST () in a query that selects distinct fields ($query = "SELECT distinct) and be able to rank them by order?

It would look something like this if it were possible:

$query = "SELECT DISTINCT product, code
	      		FROM items
	      		WHERE MATCH (product,code) AGAINST ('$search') ORDER BY Relevance DESC";

Code (markup):

 

try first, without doing anything, you never study well so try first...then ask questions....also please read the below article also, its will help...

http://www.joedolson.com/boolean-query-in-mysql.php

Vinod