MySQL SELECT question

[WarInc]

Im new to the whole hacking sceen so if this was answered a long time ago Im sorry.

Is it possible to include wildcards in select statements?

for instance:
SELECT db.table.colum FROM db.table
HAVING db.table.colum2 = *'Member of the Month'*

The problem Im haveing is our board has some extra credits like Member of the Month, Court Jester, etc .. and we can't create new user groups due to the fact that we wish to keep the old User Title their. TIA!!!

[Admin]

Yes you can, you use LIKE. Just remember that % is a wildcard, not *.

[sql]SELECT db.table.column FROM db.table
WHERE db.table.column2 LIKE '%Member of the Month%';[/sql]
Just don't use this on large tables since it will cause a huge table scan. And avoid using wildcards at the beginning so MySQL can use the index on that column (if there is one).

You can also use regular expressions in MySQL, just use REGEXP followed by the expression.

Docs: http://www.mysql.com/doc/S/t/String_...functions.html