devxlogo

Searching a Database for a Keyword

Searching a Database for a Keyword

Question:

When setting up a recordset, is it possible to get a record when the field contains more than the word that I’m looking for and where the words are in no particular order?

For example:

StrName = 'Direct'	RSShops = Server.CreateObject("ADODB.Recordset")	strSql = "SELECT * FROM Shops WHERE Name =         '" & StrName & "'

Can I get the recordset to contain any shop/company with ‘direct’ in it’s name?

Answer:

Instead of using the Equal to (=) operator, use the LIKE operator in your SQL Statement.

To hunt for Shops with names that have the word ‘direct’ in them, your SQL statement would look like this:

SELECT * FROM Shops WHERE Name LIKE '%direct%'

You can thus modify your code accordingly.

See also  11 Effective Keyword Research Tools and Techniques
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist