CV Database Techniques: Using Boolean Logic For Applicant Searches

<div class="grey-callout"><h2>Key Takeaways</h2><ul>
<li>Use specific Boolean operators: Combine keywords using AND, OR, and NOT to refine your search results.</li>
<li>Use variants, and even make mistakes!: By considering all phrasings and spellings of job titles, you'll likely increase your search results.</li>
</ul></div>

What is Boolean Logic?

Developed by mathematician George Boole in the mid-19th century, Boolean logic is the basis of modern computer logic and is used to build logical expressions.

There are three basic operations in Boolean logic: AND, OR and NOT. You can also use brackets ( ) to partition a search. These can be used to create search queries that allow you to search a CV database more effectively. For example, you might use Boolean logic to search for candidates who have certain skills or qualifications.

‍

How Boolean Logic Can Help Search a CV Database

Here are a few examples using AND, OR and NOT:

1. To search for candidates who have specific skills, use the AND operator. For example, enter “software AND developer” to find candidates who have both “software” and “developer” listed on their CVs.
2. To search for candidates who have one of several skills and to allow for alternative spellings, use the OR operator. For example, enter “accountant OR bookkeeper OR book keeper OR book-keeper” to find CVs containing “accountant” or “bookkeeper” and allow for spelling variants.
3. To exclude candidates who have a specific skill or qualification, use the NOT operator. For example, enter “sales NOT manager” to find candidates who have “sales” but not “manager” on their CVs.

Using ( ) can help you partition search queries. For example:

1. Search for “software AND (developer OR engineer)”.
2. Streamline a query, for example “accountant OR (bookkeeper OR book keeper OR book-keeper)”.
3. Similarly, enter “sales OR telesales NOT (manager or management)”.

‍

Be Careful When Using Boolean Logic

By combining operators in various ways, you can create complex search queries that allow you to find the most relevant candidates in a CV database. However, bear in mind the following:

1. There can be false positives. These are cases where your keywords are contained in CVs that aren’t actually relevant. For example, after searching “sales manager” a CV might come up because it contains the phrase “reporting to the sales manager”.
2. You expect jobseekers to include all relevant information on their CVs. But they may use synonyms you hadn’t thought of or leave out relevant experience because it was a long time ago.
3. It’s easy to make a mistake. The input fields are often small, making it difficult to review queries (I recommend writing them in a document then copying and pasting over). Boolean search queries are sensitive: one operator in the wrong place and the results won’t be what you think you asked for.

Boolean logic could save you time in refining search queries in CV databases. But if you’re not used to it, you may be left with a nagging feeling that you might have done it wrong. If that’s you, forget about Boolean logic and instead use broad keywords and phrases. For example, instead of “software developer” search for “developer”.

‍

<span class="purple-callout"><p>Need some expert help? I'm available for advice or practical assistance. Get your free consultation.</p><p>You may also find my best-selling talent acquisition book helpful, and I can post a job on the UK's leading job sites for only £199.</p></span>

‍

Additional Resources

• Recruitment Book; The Secrets of Great Recruitment: How to Recruit Great Employees.
• Downloadable PDF guide; Navigating Job Sites Like a Pro: Strategies to Fill Your Vacancies Fast.
• Downloadable PDF guide; Efficient Strategies for Using CV Databases to Find Applicants.
• Article; Advertise a Job: How Choosing the Wrong Job Site Could Cost Your Thousands!
• Article; Choosing the Right Job Site to Advertise a Job: A Simple Guide for Employers.
• Article; CV Databases Exposed: Are They Really Worth Your Time and Money?
• Article; Using a CV Database: Best Practices for Sifting Through CVs.
• Article; How AI is disrupting Job Boards, Recruitment & HR.
• Article; Advantages & Disadvantages of Using Job Sites for Advertising Jobs.
• Article; How to Advertise a Job - Best Way to Advertise Job Openings.
• Article; What is a Job Site and When Should an Employer Use Them?