₦airaland Forum

I want to create an application that search the database with keywords but i could only search by typing the complete name of the product i want to search. Pls, help.Thanks in advance

This is not a java problem but a search problem. You should query the database using the (IN) keyword.

SELECT * FROM [tablename] WHERE [columnname] IN [keywords]

Its obviously nt a java code error,get ur queries ryt,learn hw to search string literals,substrings,emtc

Ur issue is not domain-specific,but u may try to under the Regular expressions and substrings in java they will go a long way to help and have it in mind that u nid a preloaded database, literals

I don't know if U have sold the problem but U might try retrieving all the names of the products and searching through them anyway U want. I hope U understand what I mean

try using a like sql statement.

select * from [tablename] where [columnName] like '% [keyword] %'

this is syntax for T-SQL implement it in your own way.