Hi everybody,

I've installed MySQL tools. I'm wondering where can I find documentation for MySQL syntax, can I download something or what would be the best way to learn MySQL functions /commands?

In particular, I was looking for PATINDEX analogue with RegExp pattern to search for. My colleague found this function

http://forums.mysql.com/read.php?118,229993,240768#msg-240768

and I know of

http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/sql-server-extracting-data-again

and I'm wondering whether it's possible to implement in MySQL a better function. And also how should I call the UDF in mySQL in code.