0

I am trying to make a query that will find a specific word like "mark" in a string from my data base. I don't know how to do it. I tried with INSTR and some other solutions from different sites but it doesn't work. (P.S.: I am working in Java).

Improve this question

1 Answer 1

Reset to default
1

The INSTR function should work here, assuming there aren't other unmentioned problems with your data:

SELECT *
FROM yourTable
WHERE INSTR(some_column, 'mark') > 0;
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.