Back
fulltext query on multiple attributes
TL;DR
To search for a string in multiple attributes, you can create a new field named "search" and concatenate all the values you want to search, separated by spaces. Then, add a fulltext index only to this "search" field. This approach works better with MariaDB's full-text search.
To implement this solution:
1. Create a new field named "search" in your table.
2. Concatenate the values of the name, surname, and email fields and store them in the "search" field, separated by spaces.
3. Add a fulltext index only to the "search" field.
By using this approach,
