How to pull list of all the customer with first_name as alphanumeric value

I have a table name clients, now I want to pull a list of all the customers having first_name as alphanumeric value as an example, jriqbal23, sam45del etc.

If I need to pull the details of single customer, I can run below SQL:

select customer_id,email,first_name,last_name,middle_name from clients

how to change this query for pulling the list of all the customer having first name in similar way ?

thanks in advance.

Read more here:

Content Attribution

This content was originally published by Iqbal at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: