SELECT customer_name ,  customer_id FROM customers WHERE customer_address LIKE "%TN%"
What are the names and ids of customers whose address contains TN?
SELECT customer_name , customer_id FROM customers WHERE customer_address LIKE `` % TN % ''
select customer_name , customer_id from customers where customer_address like value
What are the names and ids of customers whose address contains TN ?