 <p>It seems that you want the column value to match the start of your pattern:</p> <pre><code>SELECT * FROM my_table WHERE 'example.com' LIKE CONCAT(my_table.my_column, '%'); </code></pre> <p>The downside of this is that it isn't going to use any indexes on my_column.</p>