Why is this code not returning any values?

Question

I'm using MySQL and I'm trying to return values of CustomerLastName that starts with M, and I know there are some in the database, but they are not being returned. I see CustomerLastName and CustomerFirstName but no names.

SELECT 'CustomerFirstName', 'CustomerLastName'

FROM customer

WHERE LEFT(CustomerLastName, 1 = 'M ');

score 1 · Accepted Answer · answered Mar 15 '20 at 06:20

1

Remove the Single Quotes from select statement

SELECT CustomerFirstName, CustomerLastName

FROM customer

WHERE LEFT(CustomerLastName, 1 = 'M ');

answered Mar 15 '20 at 06:20

Aditya Rewari

2,343
2
23
36

score 0 · Answer 2 · answered Mar 15 '20 at 08:50

As well as the incorrect quotes in the select WHERE LEFT(CustomerLastName, 1 = 'M '); is not syntactically correct - and you should be seeing a raft of warnings.

Change to

WHERE LEFT(CustomerLastName, 1) = 'M';

And review When to use single quotes, double quotes, and backticks in MySQL

Why is this code not returning any values?

2 Answers2