FUNCTION tcase does not exist

Question

FUNCTION db_name.tcase does not exist. I am using mysql select query i.e

select tcase(column_name) from table

which is giving error on localhost saying tcase does not exist. php version 5.6 mysql version 4.8 its working proper on live website but not on localhost

There is no function like `tcase`. Someone created it as custom function and you have used it as it is without defining. — Lovepreet Singh, Jun 26 '18 at 11:29

score 1 · Answer 1 · answered Jun 26 '18 at 11:31

1

There is no function like tcase. Someone created it as custom function and you have used it as it is without defining.

Look here Is there a simple way to convert MySQL data into Title Case?, how tcase function is defined.

answered Jun 26 '18 at 11:31

Lovepreet Singh

4,792
1
18
36

thnks for your ans – savita dhadwad Aug 23 '18 at 11:40

FUNCTION tcase does not exist

1 Answers1