Comment Comment by aexaey Percent, rather than asterisk. UPDATE t SET foo='bar' WHERE baz LIKE '$INPUT'; This will do no changes when $INPUT is empty, and only with $INPUT set to '%' will it update every record. parent aexaey 8 years ago