Query based on pattern

[Jordan Pritt]

I am having difficulty finding out if I can query based on a string or string pattern. I would think it could, but I am just not finding a solid answer. What I am trying to do is query results based on a string of either x amount of characters or a column containing 'abc' and whatever else follows after it.

example:

SELECT * FROM table WHERE col1(SELECT col FROM table2 WHERE col2='abc%%%%%');

OR

SELECT * FROM table WHERE col1(SELECT col FROM table2 WHERE col2='%%%%%%%%');


If this can be done please let me know, thanks!