Question

在MySQL中,我的计票人一样。

SELECT * , IF( `Word` =  sim , 1, IF( `Word` LIKE  sim% , 2, IF( `Word` LIKE  %sim , 4, 3 ) ) ) AS `sort`
FROM `dblist`
WHERE `Word` LIKE  %sim% 
ORDER BY `sort` , `Word`

这辆车在SQlite没有工作。我想要这样做。

SELECT * FROM dblist where word like  sim  or word like  sim%  or word like  %sim%  or word like  %sim

同等的模拟是一只手工艺品,模拟率为二倍,模拟率为百分数,而模拟为最后一刻。

目前,我可以像我的智慧一样。如何改变q子,以决定结果?

Answer 1

您应使用而不是 IF,因为后者得不到Kallite的支持。你们需要:

SELECT
    *,
    CASE WHEN `Word` =  sim  THEN 1
         WHEN `Word` LIKE  sim%  THEN 2
         WHEN `Word` LIKE  %sim  THEN 4
         ELSE 3
    END `sort`
FROM `dblist`
WHERE `Word` LIKE  %sim% 
ORDER BY `sort` , `Word`

Answer 2

SELECT * , case when `Word` =  sim  then 1 else case when `Word` LIKE  sim%  then 2 else case when `Word` LIKE  %sim  then 4 else 3 end end end as sort
FROM `dblist`
WHERE `Word` LIKE  %sim% 
ORDER BY `sort` , `Word

友情链接