Pls help me...
I want to search value in databse field.

I have stored some values in array:
$x[0]='A';
$x[1]='B';

In database i have field values like
the field name is ethinicity and the values stored in it are:
a,b,,,,

now I want to search A and B in the ethinicity field.
Pls send me the query
urgent

Thanx in advance
Raaj

Raaj,

SELECT * FROM tablename WHERE MATCH (a,b,c,d,e) AGAINST ('search keyword')

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

Try using % wildcard on your quey. In your example:
SELECT enthinicity
FROM tablename
WHERE enthinicity LIKE '%a,b%';