How can I implement search functions using search operators like Google and Bing?

I am creating a web application that allows me to manage the information of my books using CakePHP and MySQL.SQL.I have no plans to publish it to the outside world, but I started making it because I wanted to make it myself.

Here's the information in the book:

I wanted to add a search function to the web application, and I wanted to use it to search multiple times with spaces like Google, double quotation to match exactly, and narrow down the date and time.

However, if you just use SELECT statements normally, you can only use ambiguous search using LIKE clauses, which is troubling me.How do you achieve Google-like search capabilities?