Hi,

I'm trying to sort my search result with priority desc.

Thus, I get the data like this:

PHP Code:
$result mysql_query("SELECT id,status,priority,title from books
WHERE status='active' and MATCH(title) 
AGAINST ('"
.$keyword."' IN BOOLEAN MODE) 
order by priority desc, title asc limit 
$from,$limit"
or die(
mysql_error()); 
Then I echo my result:

PHP Code:
while($row=mysql_fetch_array($result)){
echo 
"<p>".$row['title']."</p>";

The script works fine but I wish to have the books that having highest priority (priority=5) to be displayed randomly. The other books will display in title asc mode.

May I know is it possible to do in the mysql query?