MySQL Substring Does Not Exist

[JBellTek]

I have a query that I have executed on a MySQL 5.3 server, but when I try to execute the same query on the MySQL 5.0 server the server returns the following error message:

Error Code : 1305
FUNCTION dbname.SUBSTRING does not exist

I have never encountered this before. I have tried using SUBSTR, SUBSTRING, and MID, with the same response. Does anyone have any idea why I am receiving this error message, and/or what to do about it?

 

[whosrdaddy]

check if you have a space before the bracket:

"SUBSTRING ("

this could generate this sort of error.

/Daddy

-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!

 

[JBellTek]

For anyone searching for an answer to this question, I have resolved the issue.

There was a white space between the opening parend and the first argument:

SUBSTR( arg1...

Removing this single whitespace resolved the issue, as is shown below:

SUBSTR(arg1...

 

[JBellTek]

whosrdaddy
I didn't see your response before I posted. Thank you for your respone.

 

[ingresman]

which is why you should post the SQL in a code block like this

select lotsof stuff from atable;