Error in ucfirst in Mysql

Question

In Select query I'm using ucfirst for getting character in caps.

My Select Query:

SELECT det.Id AS id,
       ucfirst(det.title) AS title,
       DATE_FORMAT((det.dateInt), '%M %d, %Y') AS dateint
FROM img_details det
ORDER BY Id DESC

When I'm using this query in Mysql it is showing error like:

FUNCTION admin.ucfirst does not exist.

Please give any suggestions.Thanks in Advance.

Do you want to all character in capital letter or first character of word capitalize? — Sadikhasan, Oct 07 '14 at 09:09
Visit this post : http://stackoverflow.com/questions/4263272/capitalize-first-letter-mysql — Sadikhasan, Oct 07 '14 at 09:14

score 0 · Answer 1 · answered Oct 07 '14 at 09:08

0

Try with UCASE function in mysql. There is no function available in mysql named with ucfirst

SELECT det.Id AS id,
       UCASE(det.title) AS title,
       DATE_FORMAT((det.dateInt), '%M %d, %Y') AS dateint
FROM img_details det
ORDER BY Id DESC

answered Oct 07 '14 at 09:08

Sadikhasan

18,365
21
80
122

It is working but everything coming in caps.I need only first letter to be in Caps.Thanks for your answer @Sadikhasan – Janani Oct 07 '14 at 09:13

Error in ucfirst in Mysql

1 Answers1