searching more than 1 table in mysql ?

[Anon]

Hi everyone,

i have a query like following:

$sql = " SELECT name FROM books WHERE name LIKE 'catcher'";

this works fine and gives me the result i want to. But as you can see it only looks in the table "book" for the string "catcher". How can i achive that it searches in other tables too. For instance in 3 tables. (books, magazines, letters) without making 3 single sql querys.

thanks in advance and for any kind of help

regards ali

[majik-sheff]

You can select from several tables, or you can filter. You can't do both. What you need is a UNION operator, which MySQL does not yet support. 🙁