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
where
email='jriqbal23@gmail.com';

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: https://stackoverflow.com/questions/64870307/how-to-pull-list-of-all-the-customer-with-first-name-as-alphanumeric-value

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: