Anyone know how to solve this problem?
I have several tables.
1. the main table namely lesson contains several fields that used for searching.
2. weight is assigned by users for each keyword for searching purpose.
3. users' keyword will be compared with the record in the database. each of them has their own similarity.(like lookup table)
field: form - subject - skills - time - ability
similarity table for form
fields: query- case -similarity
e.g : form1 form1 1
form1 form2 0.67
similarity table for subject
fields: query- case - similarity
e.g : science science 1
science math 0.3
table 4- similarity table for skills
table 5- similarity table for time
table 6- similarity table for ability
thanks for your help