mysql find question

[eluser]alex646[/eluser]
Hello guys,

I'm trying to create a form, this form has 5 fields:

name
work
school
city
state

I have a db and all files working, except one thing:

I want to allow user to find a record if any of the form fields match, not necessarily all of them, any of the fields. I'm not sure how to go about it using active record or sql either : (

Please help : )

Thanks

[eluser]bgreene[/eluser]
select * from tablename where ('name' like "Jobs") or ('work' like "Jobs") etc. use "Jo%" for partial match, read up on mysql

[eluser]alex646[/eluser]
Thanks! I played with it and it works now : )