MySQLi Query Issue
With this SQL I'm using in a MySQLi recordset typing in a partial value into a search field will not find any records but typing the complete value does. As an example, if I type in 'abe' no records are found, but if I type in 'abe lincoln', the record is found. Why is the LIKE condition not working in this SQL? Am I using an incorrectly formed variable? Using the MySQLi Query Builder doesn't build a successful SQL statement either.
SELECT publications.*
FROM publications
WHERE publications.Author LIKE varAuthor OR publications.Title LIKE varTitle OR publications.SubmitDate = varSubmitDate