Select * from lost where CONCAT (name, description) LIKE "% %" mathematics

How key word for "math book" can be found out? Is the result is in accordance with the keyword matching degree to arrange input "math book", can be found out "mathematics" "learning book" and other relevant data

CodePudding user response:

The create table statements and some test data is coming,