mysql> select email from aminno_member_email where email like '%mosdos%';
+-----------------------------------+
| email                             |
+-----------------------------------+
| alanramosdossantosramos@gmail.com |
| aunsomosdos@hotmail.com           |
| Carlosramosdosanjos@gmail.com     |
| dlemosdossantos@yahoo.com.br      |
| moizesramosdossantos@hotmail.com  |
| mosdos6@yahoo.com                 |
| nosloplanteamosdos@hotmail.es     |
| nosloplanteamosdos@hotmail.es     |
| nosreimosdos@yahoo.com            |
| orlandoramosdosreis@r7.com        |
| ramosdosoab@gmail.com             |
| sds@somosdosul.com.br             |
| seamosdos2@gmail.com              |
| Somosdos11@hotmail.com            |
| Somosdos11@hotmail.com            |
| somosdos188@yahoo.com.ar          |
| somosdos188@yahoo.com.ar          |
| somosdos1977@hotmail.es           |
| somosdos1999@hotmail.com          |
| somosdos2006@gmail.com            |
| somosdos2006@gmail.com            |
| somosdos230@gmail.com             |
| Somosdos38@hotmail.es             |
| SOMOSDOS38@HOTMAIL.ES             |
| somosdos483@gmail.com             |
| somosdos516@yahoo.com.ar          |
| somosdos69@yahoo.com.ar           |
| SOMOSDOS@HOTMAIL.COM              |
| somosdosamantes@gmail.com         |
| somosdosamores_20@hotmail.com     |
| somosdosenvina@hotmail.com        |
| somosdoshot@yahoo.com.ar          |
| somosdostuyyola@gmail.com         |
| somosdosymedio@hotmail.com        |
| somosdos_012@hotmail.com          |
| Yoytusomosdos@gmail.com           |
| yoytusomosdos@hotmail.com         |
| yoyyomismosomosdos@gmail.com      |
+-----------------------------------+
38 rows in set (29.18 sec)

mysql> select email from aminno_member_email where email like '%@bshemesh.co.il';
Empty set (21.11 sec)