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:alio...@yahoo.com]
Sent: Thursday, October 21, 2010 7:58 AM
To: mysql@lists.mysql.com
Subject: Percent of match in condition
On 10/21/2010 9:57 AM, Ali A.F.N wrote:
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 mat
Hmm. You might be able to hack this up using the if() function, but it's not
gonna be a beauty to look at, and possibly not terribly performant, either.
You may need to look at external data query tools - I think a number of
fulltext search tools provide match percentages in their results.
On Th
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_ta
