Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MySQL Substring Does Not Exist

Status
Not open for further replies.

JBellTek

Programmer
Jun 11, 2009
29
US
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:

Code:
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?
 
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!
 
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:
Code:
SUBSTR( arg1...

Removing this single whitespace resolved the issue, as is shown below:
Code:
SUBSTR(arg1...

 
whosrdaddy
I didn't see your response before I posted. Thank you for your respone.
 
which is why you should post the SQL in a code block like this
Code:
select lotsof stuff from atable;
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top