id name class marks
1 H 1 60
2 H 2 50
3 S 1 70
4 S 2 60
5 V 1 55
6 V 2 80
7 K 1 60
8 K 2 70
This is my table structure.
I want mysql query to get result like
id name class marks
1 S 1 70
2 S 2 60
sanjay@srvmedia
0
Newbie Poster
jj.dcruz
0
Junior Poster
do you have distinct values? so it can be call easier like status.
mysql query would be like this
SELECT `id`,`name`,`class`,`marks` FROM tbl_name WHERE name='S'
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.