Trying to add Search capabilities to the LMS

We were just trying to add search capabilities so the people could search through the list of courses already in the LMS. First in MySQL the tables in which the full text search had to be done, needs to be of a specific engine called MyISAM, MyISAM is the default engine when you don't specify any in the creation of the table, but is that true...

Well I don't know if I mis-configured something in my Windows MySQL installation, but when I tried to add the Full text search indexes to the courses table, it throws an error. So the solution for that was to specify the engine type in the script SQL that create the tables (see it on the column of the right in the section "important files").

I think the search functionality in the LMS needs to be done in that way, just to accelerate the development of it. And I also think that the search functionality could be described in just a few words:

SELECT ... FROM table_name WHERE MATCH(column1, column2) AGAINST ('search string');

This idea and the reference code for develop the above mentioned functionality, was taken (or it's going to be taken) of the nice book: MySQL Cookbook 2nd Edition