I have two table data as:
- table Classifieds
id | title | body | city | district|
- table Locations
id | label
City of table Classifieds is Id two Locations
Now I want using Fulltext Search when users enter keyword (title, body, label(USA, Canada...)) then it will return records by keyword users enter.
I'm working on a project with MYSQL and FW PHP Laravel where I believe full-text search is the best way to go. Imagine the following table structure: Classifieds
ID Title Body Location_id
1 ABC ABCD 1
2 BCD BCDE 2
3 ABC ABCD 1
4 BCD BCDE 3
As you can see. Now i want when users one keywork (USA) and will it show all recoders has keywork USA.
In this case, I have a search input box. When users enter a title, body, or label, it will also find recoder containing such information. And the only way I used to work fulltext search with it instead of using not Like