How to Change the Last Character in a String to Uppercase in MySQL
I have been working on a project that required the importing of some nasty old, badly formatted data in a nice new MySQL database.
I ended up data in a firstname field with titles and initials, for example; Mr…
Count number of words in text using MySQL
I was trying to count the number of words in some MySQL results today.
This is easy enough with PHP using str_word_count
However there is no simple command to do it in MySQL
However I found this great post that give a nifty little trick for