Search a multiple fields

[shalomajay]

Hiya,

im just programming some bits and pieces.
Just wondering if I can do a search a table across multpile fields. I mean if i have a text box & put a general search, can i get it to search across the whole table to matching entries.

select * from county where "any field" = 'mysearchword'

thanks,
Jo

[rincewind456]

SELECT FROM county WHERE field 1 = 'mysearchword' OR  field 2 = 'mysearchword' OR 
field3 = 'mysearchword'

[shalomajay]

youre a star 🙂
how would it work if the search is separated by a blank?

eg: mysearch word

cheers,
jo

[rincewind456]

The search term has to be within single quotes so even if the search was for 'My very very very long search' it would still search for it.

Be aware that it will stop at the first instance of finding the term, so if it's found in field1 it won't go on to search field2 etc.

[shalomajay]

thanks that's exactly what i wanted...cheers :-)