Uppercase abbreviated Country in MySQL -


i using following code

$wpdb->query( "update $wpdb->usermeta set meta_value = replace(meta_value, 'ontario', 'on')" ); 

it works fine, want know there way can make "on" uppercase in mysql insert?

mysql provides string function upper()

http://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_upper

it's possible reference function in insert statement.


Comments

Popular posts from this blog

java - nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet Hibernate+SpringMVC -

sql - Postgresql tables exists, but getting "relation does not exist" when querying -

asp.net mvc - breakpoint on javascript in CSHTML? -