sql - Unable to total number of words that appear in a table -



sql - Unable to total number of words that appear in a table -

i'm having problem trying find total amount of times word appears in entire table. code counts number of times word appears in each row. how around issue?

select comments, count(*) total ae comments '%'%' grouping comments

if anymore code please inquire :)

will number enough?

select count(comments) total ae comments '%'%'

sql

Comments

Post a Comment

Popular posts from this blog

php - How to pass multiple values from url -

php - How to pass multiple values from url - i'm trying pass textbox , 1 select result value 1 page page.using url.but it's display error message. "parse error: syntax error, unexpected '' (t_encapsed_and_whitespace), expecting identifier (t_string) or variable (t_variable) or number (t_num_string) in c:.." while($value= mysqli_fetch_assoc($result)){ $apid=$value['apid']; echo("<tr> <td>". $value['apid'] ."</td> <td>".$value['email']."</td> <td>".$value['comments']."</td> <td>".'<input type="text" name="payment"/>'."</td> <td>"."<input type='text' name='apid' value='".$apid."' style='visibility:hidden' size='2'>"."</a>"."<a hre...
Read more

php - Laravel not returning controller -

php - Laravel not returning controller - i have simple ajax() request that's supposed add together coupon if take take (via pop tag). however, when run page , click on tag , @ in console it's doing returning entire page in html. how can utilize controller specify via routes? new ajax sure that's problem is. what's supposed happen client clicks on take coupon button, ajax processes info controller , shows modal letting them know coupon has been added successfully. a tag <a href="#" class="btn btndefault btnsmall" id="ajaxcoupon">add coupon cart , go on shopping <i class="fa fa-arrow-right"></i></a> ajax $('#ajaxcoupon').click(function(e){ e.preventdefault(); $.get('ajaxaddcoupon', function(data){ $('#successcoupon').foundation('reveal', 'open'); }); }); controller & route ...
Read more

c# - Confused on how to specify a Platform and Version while using ChromeOptions for RemoteWebDriver with Selenium donNet since recent updates -

c# - Confused on how to specify a Platform and Version while using ChromeOptions for RemoteWebDriver with Selenium donNet since recent updates - using c# selenium 2.39 , before, able interact chromeoptions , desiredcapabilities directly. so, if wanted emulate android device on modern version of windows, code snippet might this: // define chromeoptions create chrome deed mobile device chromeoptions options = new chromeoptions(); options.addargument("--user-agent=mozilla/5.0 (linux; android 4.0.4; galaxy nexus build/imm76b) applewebkit/535.19 (khtml, gecko) chrome/18.0.1025.133 mobile safari/535.19"); options.addargument("--disable-sync-passwords"); capabilities = desiredcapabilities.chrome(); //needed find win7 vm rather linux or mac capabilities.setcapability("platform", "vista"); //cef apps tested using selenium2 , grid. //a version of "real" has ...
Read more