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

[b1randon]

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.