Search Multiple Tables of a Mysql Database
Posted
by
DogPooOnYourShoe
on Stack Overflow
See other posts from Stack Overflow
or by DogPooOnYourShoe
Published on 2011-01-04T10:51:28Z
Indexed on
2011/01/04
10:53 UTC
Read the original article
Hit count: 363
I have the following code:
$query = "select * from customer where Surname like \"%$trimmed%\" OR TitleName like \"%$trimmed%\" OR PostCode like \"%$trimmed%\"
order by Surname";
However, I have another table which I want to search from with the same paramaters(variables) as that. I know that something like "select * from customer,othertable" might not be possible, Is there a way to do it?
© Stack Overflow or respective owner
