I think the first thing you need to do is define what you mean by "80% match". There's no absolute definition of this - you need to decide what it means. Once you've done that, then you can work out how to write a query for it.
Joined: Dec 27, 2009
Basically what I want is that if the tutor's subjects and the parent's subjects are matched, it will be displayed.
Now, it gives me 100% match only :
Math = Math.
But I want to include Math, Science = Math also be included.
Hence I use the parent.subject LIKE '%' = member.subject.
Could you tell me how to query something like that and it will auto run every time the program is run? Thanks.
subject: How to write query to obtain not 100% match?