Skip to content

Instantly share code, notes, and snippets.

@nfarah86

nfarah86/find_all_customers_with_parameters.sql

Created December 14, 2020 06:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nfarah86/fd4bf950877a33ec50347737b20b1443 to your computer and use it in GitHub Desktop.
Save nfarah86/fd4bf950877a33ec50347737b20b1443 to your computer and use it in GitHub Desktop.
Download ZIP
Finds customer's history via parameters for email and full name
Raw
find_all_customers_with_parameters.sql
Select
full_name,
created_at,
active,
email,
last_updated,
customer_id
from
customer_orders
WHERE
email LIKE CONCAT('%', :email, '%')
AND full_name LIKE CONCAT('%', :name, '%')
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment