List:General Discussion« Previous MessageNext Message »
From:Travis Ard Date:October 22 2010 5:08pm
Subject:RE: Percent of match in condition
View as plain text  
Maybe you could do something like the following with user variables (or
prepared statements):

set @sex = 1, @country = 120, @education = 0;

select if(sex_id = @sex, 1, 0) + if(country_id = @country, 1, 0) +
if(education_id = @education, 1, 0) as num_matches, sex_id, country_id,
education_id
from my_table
where sex_id = @sex
or country_id = @country
or education_id = @education
order by num_matches desc;

-Travis

-----Original Message-----
From: Ali A.F.N [mailto:aliooss@stripped] 
Sent: Thursday, October 21, 2010 7:58 AM
To: mysql@stripped
Subject: Percent of match in condition

Hi All,

I have a table with different fileds and almost the type of all them are 
smallint. I want to search on some fields with "OR" condition. I want to
know is 
there possibility to know how many fileds matched exactly? then I can say
how 
many percent match are available.

select * from my_table where sex_id = 1 or country_id = 120 or education_id

I mean if in my table there are some records with sex_id = 1 or country_id
=

120  then I got 2 (2 match) then I can say 66% percent match.

Thank you,

ali


      

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1


Thread
Percent of match in conditionAli A.F.N22 Oct
  • Re: Percent of match in conditionJohan De Meersman22 Oct
  • Re: Percent of match in conditionMySQL)22 Oct
  • RE: Percent of match in conditionTravis Ard22 Oct