Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › Using SQLyog › Using Substr
Hi there
im trying to use
select substr(id, 0,3)
from mytable
to retrieve the numeric part of the string “client33”. Is this feature available in SQLyog?
I tried to do triggers and its not possible too.. How do i know what functions are supported.
Thanks
MArcus
substring, not substr.
If sqlyog doesn't color it, it's not a keyword. 🙂
=C=
No function is supported by SQLyog because it does not have to support any function. It's MySql that executes a function. All that SQLyog can do is to use different color coding for reserved words, function names, etc., to help developers.