mysql - select concat query

Question

I'm trying to list all users beginning with a letter, e.g. D

Would the following be the right method of doing this.

Select concat(firstname, '',lastname) from users where concat(lastname) = "D*"

Jacob · Accepted Answer · 2011-07-27 13:09:55Z

4

SELECT concat(firstname, '',lastname) FROM users WHERE lastname LIKE "D%"

If you want to use wildcards, you need the LIKE operator. Also, in your where clause you only have one column (lastname), so you don't need concat.

answered Jul 27, 2011 at 13:09

Jacob

43.6k6 gold badges81 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Randy · Accepted Answer · 2011-07-27 13:10:27Z

0

i would try:

select * from users where lastname like 'D%';

answered Jul 27, 2011 at 13:10

Randy

16.7k2 gold badges40 silver badges56 bronze badges

Abin Kuruvilla Chacko · Accepted Answer · 2022-08-26 15:08:10Z

-1

For getting list starting with eg: "D":

SELECT firstname FROM users WHERE LEFT(firstname,1)= 'D';

answered Aug 22, 2022 at 8:19

143 bronze badges

Please share more details. Why do you need concat in the WHERE clause?

in case of 'first name' value is null. script use the 'name' value from last name. Then it will list name start with 'D'

Please add all clarification to your answer by editing it. What makes you think that any value is NULL?

I removed all of my assumptions @NicoHaase . Now I write it as normal way.