Query not working correctly

[illdill]

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

 

[pbaldy]

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

 

[illdill]

That did it! Thanks!