Guide as a search for using fulltext search two table in FW laravel

[daocntt]

I have two table data as:
- table Classifieds
id | title | body | city | district|
- table Locations
id | label
Relationship
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.

[Dani]

What's the guide? I'm confused. Is this a question you're asking?

[daocntt]

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
boby
location_id
Location
id
label
Classified

ID  Title   Body    Location_id
1   ABC     ABCD    1
2   BCD     BCDE    2
3   ABC     ABCD    1
4   BCD     BCDE    3

Location

ID  Label
1   USA
2   Italia
3   Canada

As you can see. Now i want when users one keywork (USA) and will it show all recoders has keywork USA.

[ko ko]

Can't you write down an JOIN query ? Like below:

SELECT c.*, l.Label AS Location FROM Classifieds AS c JOIN location AS l ON c.Location_id = l.ID WHERE l.Label LIKE '%USA%'

I agree with ko_ko - an INNER JOIN should suffice. I used to think of fulltext searching being clunky and heavy, but I read an article here:

http://makandracards.com/makandra/12813-performance-analysis-of-mysql-s-fulltext-indexes-and-like-queries-for-full-text-search

which made me think again. However you seem to be searching a table with few rows of one or two words, so I doubt you'd see any time advantage from using fulltext over 'LIKE'.

[daocntt]

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?