hi,
i know there is a method for my question.
i have a database call employee with name,age,salary,address,telephone fields,
Now i want to search a word "hello", i want to search all the filed and want to return the results, php/mysql
i don't want like
select * from employee where name like '%hello%' or age like '%hello%'
please guide me.
thanks

surendran
(Anything is Possible)
http://ssuren.spaces.msn.com

__________________
surendran
(Anything is Possible)
http://www.suren.info
http://ssuren.spaces.msn.com

HI Freinds,
I found a solution,
"SELECT * FROM employee WHERE MATCH (name,age,salary,address,telephone) AGAINST ('hello')"

Thanks

surendran
(Anything is Possible)
http://ssuren.spaces.msn.com

Hi to use MATCH() AGAINST(), first thing u need to do is, you must have fulltext index on these fields and for fulltext index columns type can be char,varchar,text/blob only.

after doing this if u want that your search should be very clear n apecific i mean if u want to refime ur search which will show exacly what u want then use both MATCH() AGAINST() and Like "%"..if still having problem then query is will be like this

SELECT name,age.......from employee WHERE (MATCH(name) AGAINST('*hello*' IN BOOLEAN MODE) OR MATCH(age) AGAINST('*hello*' IN BOOLEAN MODE)) AND (name like('%hello%') OR age like('%hello%'));

a query like this will refine ur search n will giv u exact serched results..

Regards

Success is Never Ending,,Failure is Never Final

if it works for u or not ..
do reply me

Success is Never Ending,,Failure is Never Final

hai, i use IN,
It is working fine

SELECT * FROM employee
WHERE name IN ('hello')

surendran
(Anything is Possible)
http://ssuren.spaces.msn.com

thats cool

Success is Never Ending,,Failure is Never Final

gr8 and simple solution to a big prob nice for ya guys

---
Paagle
TEAM LEADER-Team Xuberance(http://www.xuberance.com)