[SOLVED] How do I search through all of my database fields

[m00ch0]

"SELECT * FROM scontrol WHERE scan LIKE '%$search%'"

 

Currently its only search through scan as you can see above

 

thanks in advance

[Fadion]

u mean:

 

"SELECT * FROM scontrol WHERE scan LIKE '%$search%' AND print LIKE '%$search%' AND open LIKE '%$search%'"

[Jessica]

I think you'd want to use OR, not AND.

[m00ch0]

Thanks alot works prefect i used the Or insted of and

 

cheers

[AV1611]

select * from table where field='blah' and field2='blah' or (field='blah' and (field3='blah' or (field4='blah' or isnull(field5))))

 

 

(WAY too much coffee this morning...)