SELECT customer_name ,  customer_id FROM customers WHERE customer_address LIKE "%TN%"
Return the names and ids of customers who have TN in their address.
SELECT customer_name , customer_id FROM customers WHERE customer_address LIKE `` % TN % ''
select customer_name , customer_id from customers where customer_address like value
Return the names and ids of customers who have TN in their address .