469,270 Members | 1,733 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,270 developers. It's quick & easy.

Need a Query for ........

donilourdu
Hi every One
In my prtoject i need to search like following

an example

table name : emp
fields : e_no, First_name, Last Name, Street_Address ,Phone_no

e_no | First_Name | Last_Name | Street_Address | Phone_no
-----------------------------------------------------------------------------------------
1 | Bell | wilson | 123 Sanantino | 23455677
2 | Don | Dickson | 34 Alabama | 8425612
3 | Jone | David | 23, Corson | 5468213

in the above table I need to search like that. If i give Like
one

i need result like following

e_no | First_Name | Last_Name | Street_Address | Phone_no
-----------------------------------------------------------------------------------------
3 | Jone |David | 23,Corson | 546821

wth regards
Doni
Jan 13 '07 #1
1 929
b1randon
171 Expert 100+
Hi every One
In my prtoject i need to search like following

an example

table name : emp
fields : e_no, First_name, Last Name, Street_Address ,Phone_no

e_no | First_Name | Last_Name | Street_Address | Phone_no
-----------------------------------------------------------------------------------------
1 | Bell | wilson | 123 Sanantino | 23455677
2 | Don | Dickson | 34 Alabama | 8425612
3 | Jone | David | 23, Corson | 5468213

in the above table I need to search like that. If i give Like
one

i need result like following

e_no | First_Name | Last_Name | Street_Address | Phone_no
-----------------------------------------------------------------------------------------
3 | Jone |David | 23,Corson | 546821

wth regards
Doni
Please give this a shot on your own. It is very basic. I'll be happy to help if you get stuck. Use this link: http://dev.mysql.com/doc/refman/5.0/en/select.html.
Jan 13 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by lawrence | last post: by
9 posts views Thread by netpurpose | last post: by
10 posts views Thread by L. R. Du Broff | last post: by
3 posts views Thread by pbd22 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.