mysql - How to replace html symbols via sql query on php -


i have situation have custom field html symbol (‚). when try replace equivalent (,) cannot it...

i'm using sql query:

$wpdb->query ("update $wpdb->postmeta set `meta_value` = replace(`meta_value`, \'%‚ %\') `meta_value` '‚'");

what doing wrong?

to convert ‚ comma, use replace below: 

select replace(meta_value, '‚', ',') your_table meta_value ','

shown select statement testing, actual update:

update set your_table set meta_value = replace(meta_value, '‚', ',') meta_value ','

-

Comments

Post a Comment

Popular posts from this blog

PHP change url style -

let's got file called test.php , can gather information using test.php?id=(id) . i'm using iis , i've managed remove .php extensions each file, shows test?id=(id) i'm wondering how have if want show test/id/(id) . not quite sure google in situation, that's why i'm asking here. hope can me out bit, appreciated. <?php $source_url="http://www.url.com/xyz/test.php?id=1234"; //to file name $url_info=pathinfo("http://www.url.com/xyz/test.php?id=1234"); if (!filter_var($source_url, filter_validate_url) == false) { //source_url valid url; $token_url = parse_url($source_url); //parameters of url $query = parse_url($source_url, php_url_query); parse_str($query, $output); echo $url_info['filename']."/id/".$output['id']; } ?>
Read more

renaming files in a directory using python or R -

i went across similar questions of renaming files in directory using python. i have these files in directory want rename: -statistical_analysis_with_r -statistical_pattern_recognition_3rd_edition -statistical analysis r -statistical pattern recognition 3rd edition for wrote script in windows: def naming(so): import re w=re.split('[ _]+',so) r=[] in w: r.append(i.capitalize()) print(' '.join(r)) import os c in os.listdir(os.getcwd()): if c.endswith(".pdf"): os.rename(c,naming(c)) print(os.listdir(os.getcwd())) but getting error: statistical analysis r.pdf traceback (most recent call last): file "<ipython-input-79-d7f645d6d3e5>", line 4, in <module> os.rename(c,naming(c)) typeerror: rename: can't specify none path argument can what's going on? and doing same thing using r (www.r-project.org)? loads of in advance. your naming functio...
Read more

html - outline-style different in chrome compared to firefox and internet explorer -

seems firefox , ie have default of black dotted outline while chrome has default of light blue solid outline. i tried change doing this: a{ outline-style: dotted; outline-color: black; } this seems catastrophe links got dotted black outline not hovered or focused. terrible because "outline" thing can differentiate mouse focus keyboard key focus. any other idea on how make chrome's outline others ? <!doctype html> <html> <head> <style type="text/css"> body{ font-size: 1.5em; font-family: verdana; } .zone2 a{ outline-width: thick; outline-color: red; } .zone3 a{ outline-style: solid; } </style> </head> <body> outline tests:<br/> <div class="zone1"> <a href="#">test link 1</a><br/> <a href=...
Read more