Matthew Yeend wrote:but when I run it, I get string(49) "select * from project where projectNo like '%J1%'" Number of projects found:
The first thing you have to do when you are not getting the result you are expecting: run this query directly to MySQL and see if the expected results are returned. If it is, you know your query is correct (and you can look further); otherwise you need to fix your query first.