Neuer Kurs! Jeder Programmierer sollte generative KI lernen!
Kostenlose Lektion ausprobieren0
Sql query for searching keywords?
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.
1 Antwort
0
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