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

Post a Comment

Popular posts from this blog

compilation - PHP install fails on Ubuntu 14 (make: *** [sapi/cli/php] Error 1) PHP 5.6.20 -

-
i using following configuration: ./configure --with-libdir=lib --with-config-file-path=/etc/ --with-config-file-scan-dir=/etc/php5/mods-available --with-pear --enable-cli --enable-intl --with-icu-dir=/opt/icu4c --enable-bcmath --disable-cgi --enable-fpm --with-zlib --with-openssl --with-kerberos --with-bz2 --with-curl --enable-ftp --enable-zip --enable-exif --with-gd --with-jpeg-dir=/usr/lib64 --with-freetype-dir=/usr/lib64 --enable-gd-native-ttf --with-gettext --with-gmp --with-mhash --with-iconv --with-imap --with-mysql --with-imap-ssl --enable-sockets --enable-soap --with-xmlrpc --with-mcrypt --enable-mbstring --enable-embedded-mysqli --with-mysqli=mysqlnd --with-mysql-sock --with-sqlite3 --with-pdo-mysql --with-pdo-mysql=mysqlnd --with-pdo-sqlite --enable-phar --enable-pcntl and make fails after sometime giving following error: collect2: error: ld returned 1 exit status make: *** [sapi/cli/php] error 1 i searched , docs tell using make clean, did not , ‘-lresolve’ in ma...
Read more

javascript - return highlighted cells to php -

-
so using example code link select cells on table dragging build grid of numbers 1-192 part works great, curious how return "highlighted" cells php? <!doctype html public "-//w3c//dtd xhtml 1.0 transitional//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8"/> <title></title> <style type="text/css" media="screen"> table td { width:50px; height:50px; text-align:center; vertical-align:middle; background-color:#ccc; } table td.highlighted { background-color:#999; } </style> </head> <body> <form action='test.php' method='post'> <table cellpadding="0" cellspacing="1" ...
Read more

java - Creating a room by reading from a file (for a game) -

-
basically have make game , need create room reading file, one: # # 0 d room0.txt 0 # 1 e room1.txt 0 # wwww0wwwww w w w w w w w w w w w w w w w w w w w 1 wwwwwwwwww the "#" means can skip lines(they're information) , "w" places need put wall, numbers doors , blank spaces floor. i figured best way create room create method receives file , reads , put "information" string[10][10], , create method(or in main) receives string[10][10] created , creates room(adds images room), having difficulties reading file if guys me part thankful. the error when run program on line: if(r[x][y].equals("w")) if guys need class, image of game should or else forgot show please let me know , help. public void generateroom(file file){ if(file.exists()){ scanner sc = null; string[][] r = new string[10][]; int row = 0; try { sc = new scanner(fi...
Read more