how to remove row having some character in column in SQL
<p>How to remove a row from a table, where a specific column contains a specific value in it (e.g., a character) ?</p>

<p>I'd like to remove all the rows that contain the character 'a' in the column 'name'</p>