Mysql LEFT Orperator

[AbdulRehmanJanjua-InfoSec]

Some Weird checks have been in place on the server which i am testing. It doesn’t allow me to use SUBSTRING function of mysql which takes in SUBSTRING(str, pos, len). But i want to use LEFT function LEFT(string, length). I think so this function is not supported yet by bbqsql or i dont know how to utilize it.

[AbdulRehmanJanjua-InfoSec]

I found that i can use left and right combined to act as SUBSTRING select RIGHT(LEFT("BQQSQL",1),1)

[AbdulRehmanJanjua-InfoSec]

i found mid function could also be use MID('w3resource',11,1)