I have a table called orders with columns firstname , lastname,city ,state and zip. I need to compare the result of the query to hardcoded values. example select firstname, lastname, city,state,zip from orders where orderid='o1'
How can i do that with minimum lines of code. The request has the values which are hardcoded. when i run the request the values are saved in the DB.