Pablo Guides

CREATE TABLE people (

id INT AUTO_INCREMENT PRIMARY KEY,

full_name VARCHAR(255),

email VARCHAR(255),

phone VARCHAR(64),

role VARCHAR(255),

notes TEXT,

FULLTEXT KEY ft_people (full_name, role, notes)

) ENGINE=InnoDB;

SELECT id, full_name, email, phone, role,

MATCH(full_name, role, notes) AGAINST ('+"מנהל" +"אבטחת מידע"' IN BOOLEAN MODE) AS score

FROM people

ORDER BY score DESC

LIMIT 20;