Wie konvertiert man diese Abfrage in Laravel? Bitte helfen Sie
SELECT * FROM (SELECT xxx_details.xxx_id AS id, 'xxx' AS restult_type, start_time, ( MATCH ( xxx_search_tags.xxx_search_tag ) AGAINST ('test') * 10 ) + ( MATCH ( xxx_search_tags.xxx_search_tag ) AGAINST ('search') * 10 ) AS relevance FROM xxx_details WHERE xxx_status = 'active' AND MATCH ( xxx_search_tags.xxx_search_tag ) AGAINST ('\'test search\'*' IN BOOLEAN MODE) AND privacy_type = 'public' GROUP BY xxx_details.xxx_id UNION SELECT yyy_details.yyy_id AS id, 'yyy' AS restult_type, start_time, ( MATCH ( yyy_details.yyy_name ) AGAINST ('test') * 10 ) + ( MATCH ( yyy_details.yyy_name ) AGAINST ('search') * 10 ) AS relevance FROM yyy_details WHERE yyy_status = 'active' AND MATCH ( yyy_details.yyy_name,yyy_details.yyy_desc ) AGAINST ('\'test search\'*' IN BOOLEAN MODE) GROUP BY yyy_details.yyy_id) ORDER BY relevance DESC, start_time ASC
尝试使用以下方法进行查询
$results = DB::select( DB::raw("SELECT * FROM some_table WHERE some_col = '$someVariable'") );