Types of Wildcards in MySql

Question

My query:

Select * From tableName Where columnName Like "[PST]%"

is not giving the expected result.

Why does this wildcard not work in MySql?

Answer 1

Thanks everyone!

For specific this question, we need to use regexp

Select * From tableName Where ColumnName Regexp "^[PST]";

For more detail over Regular Expression i.e Regexp :

https://www.youtube.com/watch?v=KoltE-JUY0c