I have a table called bannedNicks that contains only one column so far called "banned" with the type varchar(50).
Now in my C++ program I use this table to check if a nick is legal by sending a query like:
SELECT count(banned) FROM bannedNicks WHERE banned="<nick>";
But I would like to be able to have nicks in the database that looks like cr*
. Yeah, I want to use regexp but if I have something like that how can I make a question that would find the post with ^dud[e3]$ when I have the nick dude or dud3? Banning both nicks with just one post using regexp.