General SQL Query Question
Posted on 1998-12-09
How does one pass a LIKE query to all the fields in a database? For example, the following:
SELECT * from Genetics WHERE Genetics.author LIKE '%smith%'
Returns records with "smith" in the authors field, but what if I wanted to search for "smith" in ALL the fields?
SELECT * from Genetics WHERE Genetics.* LIKE '%smith%'
And it didn't work (yes, I'm new to SQL).
Any help would be appreciated.