Unnamed

mysql> select count(*) from Jobs where career_commit like '%FT%';
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from Jobs where career_commit = 'FT';
+----------+
| count(*) |
+----------+
|      265 |
+----------+
1 row in set (0.00 sec)