Re: FULL TEXT + JOIN

[Luca Prete]

Just to let you know that I'm thinking a lot about it... I post you my first ""soultion"" that of course doesn't work for some reason...

SELECT u.id, u.name, u.surname, u.city, u.img, f.status FROM (
SELECT id, name, surname, city, img,
MATCH(name, surname) AGAINST('*m*' IN BOOLEAN MODE) AS importance
FROM users
WHERE MATCH(name, surname) AGAINST('*m*' IN BOOLEAN MODE)
ORDER BY importance DESC
) u RIGHT JOIN (
SELECT idReceive, status,
FROM friendships
WHERE MATCH(idRequest) AGAINST('54')
) f ON u.id=f.idReceive


Luca Prete