Y
Hacker News
new
|
ask
|
show
|
jobs
by
aexaey
3007 days ago
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.