如何将此查询转换为Laravel?请帮忙
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 Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
尝试使用以下方法进行查询
$results = DB::select( DB::raw("SELECT * FROM some_table WHERE some_col = '$someVariable'") );