MySQL Query

[Anon]

Hi!

I try to write a search for a php/mysql-based webforum.
each forum has its entries, subjects, authors, etc. stored in one table. (eg. f1, f2, ...)

I want to write a query which selects for example all entries in all forums (e.g. tables) whose subject is 'test'.

I tried:

SELECT f1.id,f1.subject,f1.entry,f2.id,f2.subject,f2.entry,f3.id,f3.subject,f3.entry FROM f1,f2,f3 WHERE (f1.subject LIKE '%test%') OR (f2.subject LIKE '%test%') OR (f3.subject LIKE '%test')

But this won't return any results, although there are subjects with "test" in it! Any Ideas? tia!

[[deleted]]

First of all, why are you using different tables for each forum?

Second, if a LIKE does not return matches, it's because there are no matches.
Are you sure the subjects contain 'test' in lowercase?

PS your query is missing a % in the last LIKE statement.

---

A forum, a FAQ, email notification, what else do you need?

Time to YAPF!: http://www.hvt-automation.nl/yapf/

[Anon]

Hi,

I'm sure there is such an entry.
When I do:

SELECT f1.subject,f1.entry
FROM f1
WHERE (f1.subject LIKE '%test%')

I get a record!

Any hints?