searching more than one field

[Radioactive Frog]

i have this query for searching one field

 

SELECT * FROM `hotels` WHERE hotelname LIKE \'%j%\'

 

at it works ok, but i would like to search say two more fields i thought it would be like below but that dont work please could someone point out where i am going wrong....thanks

SELECT * FROM `hotels` WHERE hotelname OR hotelcountry OR hoteladdress LIKE \'%j%\'

 

thanks

[Tmic]

more like this:

 

select * from hotels where \' *j%\' in (hotelname,hotelcountry,hoteladdress);

[Radioactive Frog]

that doesnt show any results when i test it in phpmyqdmin

[Tmic]

sry the second * must be % ofcourse

 

this works on my system but I don\'t use phpadmin

[Radioactive Frog]

yeah i had changed that, sorry i should have saidm but it doesnt make any difference

[nabeel21]

SELECT * FROM hotels WHERE hotelname LIKE \'%j%\' OR hotelcountry LIKE \'%j%\' OR hoteladdress LIKE \'%j%\' 

 

and make sure that the data in mysql table is all lowercase, cuz you are using \"j\".

 

goodluck

[Radioactive Frog]

thanks i will try it, j is only a test to see if it works i will put a \'%$search%\' there when i put it on the php page !!

 

thanks again

[Radioactive Frog]

great that works for that, but what about if i had to search variables coming in? how would i incorporate that? i have tried a couple of things but they dont work

 

any ideas?

 

thanks again