Sql query for searching keywords?

Question

Sql query for search like going or Amazon mean it have to search each word in the search return the related information only.If I search "black Lenovo 6000 " then it have given the results about black Lenovo 6000 model only. But in database color is a field, Lenovo is a brand field and 6000 is model field.

Answer 1

select * from table_name where name='black lenovo 6000'
Here the table_name is the table or database where keywords are stored.
You can also use (select 1) if you want to retrieve only one result for the given keyword