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 firstname.lastname@example.org';
how to change this query for pulling the list of all the customer having first name in similar way ?
thanks in advance.