SELECT first_name,last_name FROM users Where username= "Wig_lady";

Question

In our e-commerce database we have a users table with the columns id, username, password, first_name and last_name.

Write a SQL query that retrieves the first and last names only where the username is equal to "wig_lady".

This query is not working, any help would be appreciated

Answer 1 · 2016-02-27T21:03:22Z

February 27, 2016 9:03pm

The database string comparison is case-sensitive.

Answer 2 · 2017-05-21T19:41:33Z

May 21, 2017 7:41pm

SELECT first_name, last_name FROM users WHERE username = "wig_lady";

Answer 3 · 2016-07-21T15:08:22Z

July 21, 2016 3:08pm

select first_name, last_name from users where username = "wig_lady";

Answer 4 · 2023-01-04T05:17:42Z

January 4, 2023 5:17am

SELECT first_name, last_name FROM users WHERE username = "wig_lady";