how to search multiple word in mysql

For this we ned to use Boolean full-text searches and AGAINST keyword

if we want to search php 7 in my books table we can use folling query

SELECT *
FROM books
WHERE MATCH(desc)
AGAINST(‘”PHP 7″‘ IN BOOLEAN MODE)
LIMIT 10