danielhpavey.uk

A sorta, kinda, web development and design blog...

Posts tagged #mysql:

Change Last Character in String to Uppercase in MySQL

Thursday 11 February 2016

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…

Tags: #mysql #webdev

Count number of words in text using MySQL

Monday 10 September 2012

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

Tags: #mysql #tips #web development