SQL injection · Question 10 of 12

What must you additionally consider in a LIKE search with user input?

1 answer is correct. Medium

Show answer

Answer

  • A Neutralise % and _ with escapeLikeWildcards()

Explanation

Even bound values can contain % and _ and thus match more than intended. escapeLikeWildcards() masks them, after which you add your own placeholders.

Certifications & exams

Which exam comes next?

You can already practise for 19 exams, and 21 are up for a vote. See all certifications with their official information, cast your vote or suggest your exam.

See all certifications