<p dir="auto"><strong>Migrated issue, originally created by Alex Rothberg</strong></p>
<p dir="auto">Right now <code class="notranslate">startswith</code> uses <code class="notranslate">LIKE</code>. It would be good if there were a flag it took that would use <code class="notranslate">ILIKE</code>. The same would be good of the <code class="notranslate">contains</code> operator.</p>
<p dir="auto"><strong>Migrated issue, originally created by jvanasco (<a href="https://github.com/jvanasco">@jvanasco</a>)</strong></p>
<p dir="auto">discussed previously in</p>
<ul dir="auto">
<li><a href="https://groups.google.com/forum/#!searchin/sqlalchemy/icontains/sqlalchemy/MUyt8zYaP0c/ht4fGR9q9w8J" rel="nofollow">https://groups.google.com/forum/#!searchin/sqlalchemy/icontains/sqlalchemy/MUyt8zYaP0c/ht4fGR9q9w8J</a></li>
<li><a href="https://groups.google.com/forum/#!searchin/sqlalchemy/icontains/sqlalchemy/331XoToT4lk/RPjIYNTkSEIJ" rel="nofollow">https://groups.google.com/forum/#!searchin/sqlalchemy/icontains/sqlalchemy/331XoToT4lk/RPjIYNTkSEIJ</a></li>
</ul>
<p dir="auto">I tried doing this myself, but don't know enough of the internals to get this done on my own.</p>
<p dir="auto">it looks like these need to be modified</p>
<ul dir="auto">
<li>sqlalchemy/sql/default_comparator.py</li>
<li>sqlalchemy/sql/operators.py</li>
</ul>
<p dir="auto">but not sure about</p>
<ul dir="auto">
<li>sqlalchemy/sql/compiler.py</li>
</ul>
<p dir="auto">there are probably more files.</p>
<p dir="auto">if someone can get one working, I can do the rest and build out tests.</p>