I have started a new job and inherited a very bad database system - they use keywords to join everything up - no primary keys - anyway!
The keywords specifying to a certain course are listed in a text field as 3, 13, 56 so to find courses that contain the keyword 6 i do a SQL for:
SELECT * FROM PostGrad WHERE keywords LIKE '6';
and I get no results - I do however know that there are loads that should come up! Am I doing something really stupid or is the database just wrong! It's an Access one if thats any help!
Hope someone can help!
Ross
The keywords specifying to a certain course are listed in a text field as 3, 13, 56 so to find courses that contain the keyword 6 i do a SQL for:
SELECT * FROM PostGrad WHERE keywords LIKE '6';
and I get no results - I do however know that there are loads that should come up! Am I doing something really stupid or is the database just wrong! It's an Access one if thats any help!
Hope someone can help!
Ross