Tuesday, 20 August 2013

Getting same result based on different input

Getting same result based on different input

Let me repost my question. I think my previous question might confuse
people. Sorry for the confusion.
I have a table called vuln_info and I am trying to query based on vuln_name.
If I query like this
SELECT vuln_id FROM vuln_info where vuln_name="Self-Signed SSL/TLS
Certificate"
I have row like
vuln_id vuln_name
100 Self-Signed SSL/TLS Certificate
It returns vuln_id(100) because the vuln_name exactly match with input
However, input can be changeable. It can be like
"Self-Signed SSL/TLS Certificate present" or "machine Self-Signed SSL/TLS
Certificate" which contains Self-Signed SSL/TLS Certificate
What is the way to write query to get vuln_id(100) even though input has
extra String.
Thank you.

No comments:

Post a Comment