mysql database query [Resolved]

Posted by Sahaj.seema under Others on 2/25/2010 | Views : 1108 | Status : [Member] | Replies : 1
what is a query to select the records from table that starts with capital a




Responses

Posted by: Rajujrk on: 2/25/2010 [Member] Starter

Up
0
Down

Resolved
Hai,

Assume your table structure is like below

Username Password
=========================
Abhi ****
Anitha ****
Raju ****
Rahul ****
Abhishek ****


your Query For select records starts with A is given below
[code]
SELECT username FROM logindet WHERE username LIKE 'a%';
[/code]

Output will be like this

Username
=========
Abhi
Anitha
Abhishek


Thanks & Regards

Rajkumar J

Sahaj.seema, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response