Searching multiple fields

[EffakT]

So, I am attempting to create a search function, and I have

SELECT * FROM topics WHERE Subject LIKE '%New%' OR content LIKE '%New%' AND Author = (SELECT * FROM users WHERE Name = 'EffakT')

It should search the subject and content for New, where the author is EffakT.

 

This query doesn't work, so I was wondering if anybody could help me out?

 

Thanks

 

 

--EffakT

[trq]

You should be using a JOIN rather than a sub query. It's a bit hard to post a good example given the (lack of) information you have provided but something like:

 

SELECT * FROM topics t

LEFT JOIN users u ON (t.user_id = u.id)

WHERE (t.Subject LIKE '%New%' OR t.content LIKE '%New%')
AND u.Author = 'EffakT'

[EffakT]

You should be using a JOIN rather than a sub query. It's a bit hard to post a good example given the (lack of) information you have provided but something like:

 

SELECT * FROM topics t

LEFT JOIN users u ON (t.user_id = u.id)

WHERE (t.Subject LIKE '%New%' OR t.content LIKE '%New%')
AND u.Author = 'EffakT'

Awesome man! thanks so much <3