Добрый день, помогите пожалуйста
Есть база в ней таблица, из которой нужно удалить все, кроме записей которые в названии содержат специальный символ $$

mysql> DESCRIBE glpi_softwares;

+-----------------------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------+---------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| entities_id | int(11) | NO | MUL | 0 | |
| is_recursive | tinyint(1) | NO | | 0 | |
| name | varchar(255) | YES | MUL | NULL | |
| comment | text | YES | | NULL | |
| locations_id | int(11) | NO | MUL | 0 | |
| users_id_tech | int(11) | NO | MUL | 0 | |
| groups_id_tech | int(11) | NO | MUL | 0 | |
| is_update | tinyint(1) | NO | MUL | 0 | |
| softwares_id | int(11) | NO | MUL | 0 | |
| manufacturers_id | int(11) | NO | MUL | 0 | |
| is_deleted | tinyint(1) | NO | MUL | 0 | |
| is_template | tinyint(1) | NO | MUL | 0 | |
| template_name | varchar(255) | YES | | NULL | |
| date_mod | datetime | YES | MUL | NULL | |
| users_id | int(11) | NO | MUL | 0 | |
| groups_id | int(11) | NO | MUL | 0 | |
| ticket_tco | decimal(20,4) | YES | | 0.0000 | |
| is_helpdesk_visible | tinyint(1) | NO | MUL | 1 | |
| softwarecategories_id | int(11) | NO | MUL | 0 | |
| is_valid | tinyint(1) | NO | | 1 | |
| date_creation | datetime | YES | MUL | NULL | |
+-----------------------+---------------+------+-----+---------+----------------+





SELECT * FROM glpi_softwares WHERE name != "bimba";

| 22835 | 0 | 0 | Standard Notes | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2017-01-23 09:57:38 | 0 | 0 | 0.0000 | 1 | 0 | 1 | NULL |
| 22836 | 0 | 0 | FileZilla Client 3.24.0 | NULL | 0 | 0 | 0 | 0 | 0 | 376 | 0 | 0 | NULL | 2017-01-23 11:04:16 | 0 | 0 | 0.0000 | 1 | 0 | 1 | NULL |
| 22837 | 0 | 0 | Devart Review Assistant 3.5.345 | NULL | 0 | 0 | 0 | 0 | 0 | 631 | 0 | 0 | NULL | 2017-01-23 12:33:03 | 0 | 0 | 0.0000 | 1 | 0 | 1 | NULL |
| 22838 | 0 | 0 | $$ AxureRP Pro Subsc | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2017-01-25 11:57:29 | 0 | 0 | 0.0000 | 1 | 0 | 1 | NULL |
| 22839 | 0 | 0 | $$ Google Play account /PY2017/ | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2017-01-25 12:00:42 | 0 | 0 | 0.0000 | 1 | 0 | 1 | NULL |
| 22840 | 0 | 0 | Adblock Plus for IE (32-bit and 64-bit) | NULL | 0 | 0 | 0 | 0 | 0 | 905 | 0 | 0 | NULL | 2017-01-23 17:52:53 | 0 | 0 | 0.0000 | 1 | 0 | 1 | NULL |
| 22841 | 0 | 0 | PathWise 2.11.517 | NULL | 0 | 0 | 0 | 0 | 0 | 521 | 0 | 0 | NULL | 2017-01-23 21:37:36 | 0 | 0 | 0.0000 | 1 | 0 | 1 | NULL |
| 22842 | 0 | 0 | Docker Toolbox version 1.13.0 | NULL | 0 | 0 | 0 | 0 | 0 | 1071 | 0 | 0 | NULL | 2017-01-23 21:48:06


Спасибо за быстрый ответ, надо удалить все записи кроме тех что имееют символы $$

Да, то что надо! большое спасибо