Percentage sign in MySql

mysql

Solution

Why don't you try it yourself and see? At any rate, here are the docs you were looking for:

With LIKE you can use the following two wildcard characters in the pattern.

Character Description

% Matches any number of characters, even zero characters

_ Matches exactly one character

http://dev.mysql.com/doc/refman/5.6/en/string-comparison-functions.html#operator_like

Problem

Does it also match empty string, or only non-empty strings? I have been trying to find a reference unsuccesfully.

Original source