Normally, when you receive a request for an incorrect search function, you will immediately think of the following query:
SELECT id,title,description FROM book WHERE title LIKE ‘%keyword%’
But it has some limitations: inaccuracy, slow query speed, problems with accented and unaccented Vietnamese.
In this case you can apply Full Text Search to solve the above problems.
