MySQL - Filter based on the first character of a column in a select query

Question

Names:

Watts, Odysseus D.
Schultz, Wilma D. 
Mckinney, Madaline R.  
Charles, Mohammad O.

My table names like this structure, first_name and last_name are in single column called names, i want to get all names from starting with letter 'M' in their last name,

How to write in mysql query for this criteria???

GMB · Accepted Answer · 2020-06-19 09:10:34Z

2

If the last name appears at the beginning of the string, the you can just do:

select * from names where name like 'M%'

On the other hand, if you want to filter on the first character after the comma, then:

select * from names where name like '%, M%'

answered Jun 19, 2020 at 9:10

GMB

224k25 gold badges103 silver badges151 bronze badges

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

Collectives™ on Stack Overflow

MySQL - Filter based on the first character of a column in a select query

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related