Simple SQL Query Returns Null For All Queries - Phpmyadmin

I am trying to query a simple table to get a users id based on their username. For some reason I am getting a null result for all of my queries.

Table creation:

CREATE TABLE users(
user_id int not null auto_increment primary key,
username text not null,
password text not null
) ENGINE=InnoDB;

Inserting a tuple:

INSERT INTO `users` (`user_id`, `username`, `password`) VALUES (NULL, 'joe', '1234');

Selecting user id based on username:

SELECT 'user_id' FROM `users` WHERE 'username' = 'joe'

Returns 0 rows… yet when I click on the table users I can see the row with username joe.

I am executing the queries in PHPMyAdmin with the users table selected so I am pretty sure it is not a schema issue.

Answers