Can anyone explain how I would search x amount of columns in x amount of tables where searchCriteria LIKE something?
I understand how to search a table as follows:
SELECT * FROM myTable WHERE searchCriteria LIKE '%Car%'
but I want to search 3 tables and a limited number of columns in each table for instances of the word Car
Is this possible and if so how?
Thanks in advance
Chris
I understand how to search a table as follows:
SELECT * FROM myTable WHERE searchCriteria LIKE '%Car%'
but I want to search 3 tables and a limited number of columns in each table for instances of the word Car
Is this possible and if so how?
Thanks in advance
Chris