Don't see why you need all of those extra ORs in there...the concatenated
name catches any of those conditions.
SELECT
p.ID,
p.CongressID
FROM
UsersPresenter u
LEFT JOIN
Presentation p
ON
(u.ID = p.SpeakerID AND p.Deleted = 0)
WHERE
1 = 1
AND
u.FirstName + u.MiddleName + u.LastName LIKE '%jan%'
AND
p.Title LIKE '%plant%'
ORDER BY
p.CongressID,
p.Title
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
