MySQL FULLTEXT searching with RIGHT JOIN between two tables



SELECT Q.*, T.`name` as `last_name` 
FROM `people` as Q 
RIGHT JOIN `details` as T 
on Q.id = T.people_id 
WHERE  MATCH (Q.name) AGAINST ('jon Stephen Jack' IN NATURAL LANGUAGE MODE) 
LIMIT 10

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s