将标题重写为:将Union查询转化为Laravel的方法
P粉819937486
P粉819937486 2023-09-15 16:56:54
0
1
391

如何将此查询转换为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
P粉819937486
P粉819937486

Derniers téléchargements
Plus>
effets Web
Code source du site Web
Matériel du site Web
Modèle frontal
À propos de nous Clause de non-responsabilité Sitemap
Site Web PHP chinois:Formation PHP en ligne sur le bien-être public,Aidez les apprenants PHP à grandir rapidement!