Searching by name both in the first name and last name from the database.

[rhepsi]

hii all,
i have aproject where...

wen i enter a text in the textbox..., accordingly it should search in teh first name and last name of the database and display the records

How to search records by name....???


plz some one help me the query...


thnx..
hepsi..

[henryrhenryr]

I think you could try a number of approaches. Two I can think of are:

1. Concatenate the two columns:

SELECT CONCAT(first_name,' ',last_name) AS name FROM table WHERE CONCAT(first_name,' ',last_name) LIKE 'name_entered_in_text_box';
 

NB - if you want exact matches don't use LIKE, just use =. If you want more results, put some wildcards (%) in your LIKE clause (ie LIKE '%henry%').

2. Search each column for the same term:

SELECT first_name, last_name FROM table WHERE first_name LIKE '%henry%' OR last_name LIKE '%henry%';
 

This will give lots of results as used % before and after and I used OR. Cut the results by using fewer '%' and using AND instead of OR.

Hope that sheds some light on your problem! Good luck!

Henry

[rhepsi]

I think you could try a number of approaches. Two I can think of are:

1. Concatenate the two columns:

SELECT CONCAT(first_name,' ',last_name) AS name FROM table WHERE CONCAT(first_name,' ',last_name) LIKE 'name_entered_in_text_box';
 

NB - if you want exact matches don't use LIKE, just use =. If you want more results, put some wildcards (%) in your LIKE clause (ie LIKE '%henry%').

2. Search each column for the same term:

SELECT first_name, last_name FROM table WHERE first_name LIKE '%henry%' OR last_name LIKE '%henry%';
 

This will give lots of results as used % before and after and I used OR. Cut the results by using fewer '%' and using AND instead of OR.

Hope that sheds some light on your problem! Good luck!

Henry

thnx for ur reply...

[wish]

Hi,

If my problem is user input one keyword then i wan to find all the columns in the tables or all the tables in the database?
Eg. table_employee, table_customer, table_product. Each tables got a lot of columns then i wan to find out the similar with the keyword record.

Can someone guide me?

Thanks

[r035198x]

Hi,

If my problem is user input one keyword then i wan to find all the columns in the tables or all the tables in the database?
Eg. table_employee, table_customer, table_product. Each tables got a lot of columns then i wan to find out the similar with the keyword record.

Can someone guide me?

Thanks

Google about how to use LIKE with wildcards.