I have two queries.
where albumname like '%[%]';
WHERE AlbumName RLIKE '.*\\[.*\\]';
Result: Artist - Song [Live]
Result: Artist- Song [Gold CD, Excplicit Lyrics]
The exact equivalency of
(note that RLIKE is just a mSQL'ish synonym of REGEXP). In short that means that
LIKE always matches the whole string, whilst
RLIKE may match any substring.
That is why I would assume that there are apparently seven AlbumNames around like
You may try to determine these seven records by
SELECT AlbumName FROM album WHERE AlbumName RLIKE '.*\\[.*\\]' AND AlbumName NOT RLIKE '^.*\\[.*\\]$';