Tuesday, 27 August 2013

simple SQL query to display values from a table based on condition

simple SQL query to display values from a table based on condition

Assume there is client and a server
Client:: Android mobile
Server:: AWS server
Server has mysql database installed in it
Database name:: Person
Tables in person Database:: "sam" and "carl"
Now mobile sends a request...
How to write an SQL query so that if mobile sends request i/p as "sam"
display all the values of sam table
But if the mobile sends an i/p as carl then dipslay all the values of carl
table
[Note] I have used statement SELECT * FROM TABLE_NAME
What i am trying to achieve is a condition response when a client request
comes in



I/p means :: say i get carl as ip .... i want to perform one query else
sam as input ... i want to perform another query
what query statement should i need to write ?



hope i am stating my problem correctly
Thanks

No comments:

Post a Comment