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
So what specifically do you need? AN example of fulltext in SQL? Did you check the online mysql manual?