# Filtering by String Values

+ String literals should use single quotes: Find the name, mass, and diameter of the planets:
  + `Earth`
  + Except `Earth`
  + `Earth`, `Mars`, and `Uranus`
```
SELECT name, mass, diameter FROM planets WHERE name ~!@= 'Earth'@!~;

SELECT name, mass, diameter FROM planets WHERE name ~!@!= 'Earth'@!~;

SELECT name, mass, diameter FROM planets WHERE name ~!@IN ('Earth', 'Mars', 'Uranus')@!~;
```

------------------------------------------------------------
```
tidb> SELECT name, mass, diameter FROM planets WHERE name = 'Earth';
+-------+------+----------+
| name  | mass | diameter |
+-------+------+----------+
| Earth | 5.97 | 12756.00 |
+-------+------+----------+
1 row in set (0.00 sec)

tidb> SELECT name, mass, diameter FROM planets WHERE name != 'Earth';
+---------+-------+-----------+
| name    | mass  | diameter  |
+---------+-------+-----------+
| Mercury |  0.33 |   4879.00 |
| Venus   |  4.87 |  12104.00 |
| Mars    | 0.642 |   6792.00 |
| Jupiter |  1898 | 142984.00 |
| Saturn  |   568 | 120536.00 |
| Uranus  |  86.8 |  51118.00 |
| Neptune |   102 |  49528.00 |
| Pluto   | 0.013 |   2376.00 |
+---------+-------+-----------+
8 rows in set (0.00 sec)

tidb> SELECT name, mass, diameter FROM planets WHERE name IN ('Earth', 'Mars', 'Uranus');
+--------+-------+----------+
| name   | mass  | diameter |
+--------+-------+----------+
| Earth  |  5.97 | 12756.00 |
| Mars   | 0.642 |  6792.00 |
| Uranus |  86.8 | 51118.00 |
+--------+-------+----------+
3 rows in set (0.00 sec)

```