I have two titles 'War and Peace' and 'Peace and Love'. When I search for 'Peace' I only get the 'Peace and Love' title, but not the 'War and Peace' title...


SELECT * FROM SearchActive Where title LIKE '::title::%' AND author LIKE '::author::%' AND subject LIKE '::subject::%'


Thanks

You need a wildcard at the beginning as well as the end.

That did it! Thanks! :)