phpMyAdmin - CHARINDEX does not exist

Posted on 2011-09-16
Last Modified: 2012-05-12
I am getting an error in phpmyadmin. When I try to run this query:

SELECT LEFT( name , CHARINDEX( ' ', name ) - 1 ) FROM `jos_users`

I get the error:
#1305 - FUNCTION rrcna.CHARINDEX does not exist

I thought that CHARINDEX was a standard function. Do I need to somehow install this function?

Question by:elliottbenzle
LVL 82

Accepted Solution

hielo earned 500 total points
ID: 36550065

Author Closing Comment

ID: 36550385

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost every time LOAD DATA INFILE comes to the rescue. Here we will try to understand some of the very common scenarios for loading data …
Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (…
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now