Is it possible to perfom a fulltext search against a joined column?
Hello I' trying to select from joined column: SELECT A.idAd, A.ads_in_Cat, A.title, A.currency, A.price, A.in_dpt, A.description, D.*, S.* FROM ads A LEFT JOIN dept D ON D.id_dept = A.in_dpt LEFT JOIN sub_cat_ad AS ON S.id_sub_cat = A.ads_in_Cat WHERE MATCH(A.title, A.description) AGAINST(:searchTerm) ...