select
*,
match(firma_unvani) against("'.$query.'" IN BOOLEAN MODE) as ft_result_1,
match(keywords) against("'.$query.'" IN BOOLEAN MODE) as ft_result_2
from
firmalar
where

(
(
match(firma_unvani) against("'.$query.'" IN BOOLEAN MODE) ||
match(keywords) against("'.$query.'" IN BOOLEAN MODE)
)
&& il='istanbul' && onay=1
)
order by ft_result_2 DESC


şeklinde ekleyebilirsin