Implementing a full text search with mysql
This article has not been rated yet. After reading, feel free to leave comments and rate it.
Question:How can I implement a full text search with mysql?
Answer:A database like mysql is not really suitable to do full text indexing/ searching but since version 3.23.23 it is possible a bit better than before.
Let's say you want to search for the terms 'mouse' and 'frame'. The important new keyword is MATCH
See the queries below: