Requiring both:
Code: Select all
$query = "SELECT foo FROM bar WHERE field LIKE '%{$lname}%' AND field2 LIKE '%{$fname}' ";Code: Select all
$query = "SELECT foo FROM bar WHERE field LIKE '%{$lname}%' OR field2 LIKE '%{$fname}' ";Moderator: General Moderators
Code: Select all
$query = "SELECT foo FROM bar WHERE field LIKE '%{$lname}%' AND field2 LIKE '%{$fname}' ";Code: Select all
$query = "SELECT foo FROM bar WHERE field LIKE '%{$lname}%' OR field2 LIKE '%{$fname}' ";