how to check exclude empty mysql field
Posted: Sat Mar 19, 2011 4:54 am
i have tried this but it is not working
i want to exclude search that the name field is empty
$query = "SELECT * FROM blogpost WHERE title LIKE \"%$trimmed%\" OR post LIKE \"%$trimmed%\" AND disable ='1' AND name IS NOT NULL";
i want to exclude search that the name field is empty
$query = "SELECT * FROM blogpost WHERE title LIKE \"%$trimmed%\" OR post LIKE \"%$trimmed%\" AND disable ='1' AND name IS NOT NULL";