1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
| SELECT *,
IF(symptomes LIKE '%$Sympt1%' AND symptomes LIKE '%$Sympt2%' AND symptomes LIKE '%$Sympt3%' AND symptomes LIKE '%$Sympt4%' AND symptomes LIKE '%$Sympt5%', 5,)
IF (symptomes LIKE '%$Sympt1%' AND symptomes LIKE '%$Sympt2%' AND symptomes LIKE '%$Sympt3%' AND symptomes LIKE '%$Sympt4%', 4,)
IF (symptomes LIKE '%$Sympt1%' AND symptomes LIKE '%$Sympt2%' AND symptomes LIKE '%$Sympt3%' AND symptomes LIKE '%$Sympt5%', 4,)
IF (symptomes LIKE '%$Sympt2%' AND symptomes LIKE '%$Sympt3%' AND symptomes LIKE '%$Sympt4%' AND symptomes LIKE '%$Sympt5%', 4,)
IF (symptomes LIKE '%$Sympt1%' AND symptomes LIKE '%$Sympt2%' AND symptomes LIKE '%$Sympt4%' AND symptomes LIKE '%$Sympt5%', 4,)
IF (symptomes LIKE '%$Sympt1%' AND symptomes LIKE '%$Sympt2%' AND symptomes LIKE '%$Sympt3%', 3,)
IF (symptomes LIKE '%$Sympt1%' AND symptomes LIKE '%$Sympt2%' AND symptomes LIKE '%$Sympt4%', 3,)
IF (symptomes LIKE '%$Sympt1%' AND symptomes LIKE '%$Sympt2%' AND symptomes LIKE '%$Sympt5%', 3,)
IF (symptomes LIKE '%$Sympt1%' AND symptomes LIKE '%$Sympt3%' AND symptomes LIKE '%$Sympt4%', 3,)
IF (symptomes LIKE '%$Sympt1%' AND symptomes LIKE '%$Sympt3%' AND symptomes LIKE '%$Sympt5%', 3,)
IF (symptomes LIKE '%$Sympt1%' AND symptomes LIKE '%$Sympt4%' AND symptomes LIKE '%$Sympt5%', 3,)
IF (symptomes LIKE '%$Sympt2%' AND symptomes LIKE '%$Sympt3%' AND symptomes LIKE '%$Sympt4%', 3,)
IF (symptomes LIKE '%$Sympt2%' AND symptomes LIKE '%$Sympt3%' AND symptomes LIKE '%$Sympt5%', 3,)
IF (symptomes LIKE '%$Sympt2%' AND symptomes LIKE '%$Sympt4%' AND symptomes LIKE '%$Sympt5%', 3,)
IF (symptomes LIKE '%$Sympt3%' AND symptomes LIKE '%$Sympt4%' AND symptomes LIKE '%$Sympt5%', 3,)
IF (symptomes LIKE '%$Sympt1%' AND symptomes LIKE '%$Sympt2%', 2,)
IF (symptomes LIKE '%$Sympt1%' AND symptomes LIKE '%$Sympt3%', 2,)
IF (symptomes LIKE '%$Sympt1%' AND symptomes LIKE '%$Sympt4%', 2,)
IF (symptomes LIKE '%$Sympt1%' AND symptomes LIKE '%$Sympt5%', 2,)
IF (symptomes LIKE '%$Sympt2%' AND symptomes LIKE '%$Sympt3%', 2,)
IF (symptomes LIKE '%$Sympt2%' AND symptomes LIKE '%$Sympt4%', 2,)
IF (symptomes LIKE '%$Sympt2%' AND symptomes LIKE '%$Sympt5%', 2,)
IF (symptomes LIKE '%$Sympt3%' AND symptomes LIKE '%$Sympt4%', 2,)
IF (symptomes LIKE '%$Sympt3%' AND symptomes LIKE '%$Sympt5%', 2,)
IF (symptomes LIKE '%$Sympt4%' AND symptomes LIKE '%$Sympt5%', 2,)
IF (symptomes LIKE '%$Sympt1%' 1,)
IF (symptomes LIKE '%$Sympt2%' 1,)
IF (symptomes LIKE '%$Sympt3%' 1,)
IF (symptomes LIKE '%$Sympt4%' 1,)
IF (symptomes LIKE '%$Sympt5%' 1,)
) as Nbre
FROM diagnostique WHERE sexe LIKE '%$sexe%' AND age_min <= '$age' AND age_max >= '$age' AND (symptomes LIKE '%$Sympt1%') or (symptomes LIKE '%$Sympt2%') or (symptomes LIKE '%$Sympt3%') or (symptomes LIKE '%$Sympt4%') or (symptomes LIKE '%$Sympt5%')
ORDER BY Nbre DESC; |
Partager