Can't determine MySQL LIKE syntax?

[Guest_imported]

Ok, this is how it looks with MSSQL, a very straight forward ANSI92 compatible LIKE with wildcards:

WHERE ((strzugriff LIKE '[1,2]%') OR (strzugriff LIKE '____________[1,2]%'))

I've tried everything in MySQL and just can't get the result. Why I have to ask for help beats me, but here it is - can anyone give me a LIKE or REGEXP that works?

WHERE ((strzugriff REGEXP '[1-2]*') OR (strzugriff REGEXP '............[1-2]*'))

...fails miserably?

 

[KarveR]

WHERE strzugriff LIKE '%[1,2]%' cuts the need for OR and will return anything remotely like the reuired. ______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.