SQL queries using "LIKE"

SQL queries using "LIKE".

 

using like, and the percent signs as wild cards, will return any string containing the word "cardiovascular".

 

ok, and would it also return any string containing the substring "cardio"?

or do you need different wild-card characters? or an operator other than "like"?

 

I could do it in Java, or probably also in Python. Programming language abilities overlap database query language abilities to some extent, but how far? and how does one decide which is the right tool for the job?

Done