I think this should work:

    UPDATE table
    SET field = REPLACE(field, &#39;string&#39;, &#39;anothervalue&#39;)
    WHERE field LIKE &#39;%string%&#39;;

    UPDATE `table` SET `field` = REPLACE(`field`, &#39;string&#39;, &#39;anothervalue&#39;)

Use the `LIKE` operator to find the rows that you care about and update them using the `REPLACE` function.

For example:

    UPDATE table_name SET field_name = REPLACE(field_name,&#39;search&#39;,&#39;replace&#39;) WHERE field_name LIKE &#39;%some_value%&#39;

Does something like this work in any way?
```
update table_name
set column_name = replace(column_name, &#39;string%&#39;, &#39;string&#39;) 
where column_name like &#39;%string%&#39;
```

I&#39;m trying to add a database-enabled JSP to an existing Tomcat 5.5 application (GeoServer 2.0.0, if that helps).

The app itself talks to Postgres just fine, so I know that the database is up, user can access it, all that good stuff. What I&#39;m trying to do is a database query in a JSP that I&#39;ve added. I&#39;ve used the config example in the &lt;a href=&quot;http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html&quot;&gt; Tomcat datasource example&lt;/a&gt; pretty much out of the box. The requisite taglibs are in the right place -- no errors occur if I just have the taglib refs, so it&#39;s finding those JARs. The postgres jdbc driver, postgresql-8.4.701.jdbc3.jar is in $CATALINA_HOME/common/lib.

Here&#39;s the top of the JSP:

    &lt;%@ taglib uri=&quot;http://java.sun.com/jsp/jstl/sql&quot; prefix=&quot;sql&quot; %&gt;
    &lt;%@ taglib uri=&quot;http://java.sun.com/jsp/jstl/core&quot; prefix=&quot;c&quot; %&gt;

    &lt;sql:query var=&quot;rs&quot; dataSource=&quot;jdbc/mmas&quot;&gt;
      select current_validstart as ValidTime from runoff_forecast_valid_time
    &lt;/sql:query&gt;

The relevant section from $CATALINA_HOME/conf/server.xml, inside the `&lt;Host&gt;` which is in turn within `&lt;Engine&gt;`:

    &lt;Context path=&quot;/gs2&quot; allowLinking=&quot;true&quot;&gt;
      &lt;Resource name=&quot;jdbc/mmas&quot; type=&quot;javax.sql.Datasource&quot;
          auth=&quot;Container&quot; driverClassName=&quot;org.postgresql.Driver&quot;
          maxActive=&quot;100&quot; maxIdle=&quot;30&quot; maxWait=&quot;10000&quot;
          username=&quot;mmas&quot; password=&quot;very_secure_yess_precious!&quot;
          url=&quot;jdbc:postgresql//localhost:5432/mmas&quot; /&gt;
    &lt;/Context&gt;

These lines are the last in the &lt;web-app&gt; tag in webapps/gs2/WEB-INF/web.xml:

    &lt;resource-ref&gt;
      &lt;description&gt;
         The database resource for the MMAS PostGIS database
      &lt;/description&gt;
      &lt;res-ref-name&gt;
         jdbc/mmas
      &lt;/res-ref-name&gt;
      &lt;res-type&gt;
         javax.sql.DataSource
      &lt;/res-type&gt;
      &lt;res-auth&gt;
         Container
      &lt;/res-auth&gt;
    &lt;/resource-ref&gt;

Finally, the exception:
 

       exception
        org.apache.jasper.JasperException: Unable to get connection, DataSource invalid: &quot;java.sql.SQLException: No suitable driver&quot;
        [...wads of ensuing goo elided]
        





The infamous java.sql.SQLException: No suitable driver found

I&#39;m a bit confused about the laws applied to web fonts. I know that it&#39;s OK to use fonts like Arial, Times Romans, Georgia, etc...I think it&#39;s illegal to use other commercial fonts.
Are there websites that provide free fonts? If there are.

Can I just use them directly without mentioning the creator of the free font or without linking the page where I download them? or I have to?

How can I use fonts on the web if I&#39;m not allowed to redistribute them in digital form?

How to use web-fonts legally?

I&#39;m looking for a way to update just a portion of a string via MySQL query.  

For example, if I have 10 records all containing &#39;string&#39; as part of the field value (i.e., &#39;something/string&#39;, &#39;something/stringlookhere&#39;, &#39;something/string/etcetera&#39;, is there a way to change &#39;string&#39; to &#39;anothervalue&#39; for each row via one query, so that the result is &#39;something/anothervalue&#39;, &#39;something/anothervaluelookhere&#39;, &#39;something/string/etcetera&#39;, is there a way to change &#39;anothervalue&#39;

MySql - Way to update portion of a string?

<p>I'm looking for a way to update just a portion of a string via MySQL query.</p>
<p>For example, if I have 10 records all containing 'string' as part of the field value (i.e., 'something/string', 'something/stringlookhere', 'something/string/etcetera', is there a way to change 'string' to 'anothervalue' for each row via one query, so that the result is 'something/anothervalue', 'something/anothervaluelookhere', 'something/string/etcetera', is there a way to change 'anothervalue'</p>


I have a huge table and I need to process all rows in it. I&#39;m always getting this Lost connection message and I&#39;m not able to reconnect and restore the cursor to the last position it was. This is basically the code I have here:

    #
    import MySQLdb

    class DB:
      conn = None
    
      def connect(self):
        self.conn = MySQLdb.connect(&#39;hostname&#39;, &#39;user&#39;, &#39;*****&#39;, &#39;some_table&#39;, cursorclass=MySQLdb.cursors.SSCursor)
    
      def query(self, sql):
        try:
         cursor = self.conn.cursor()
         cursor.execute(sql)
       except (AttributeError, MySQLdb.OperationalError):
         self.connect()
         cursor = self.conn.cursor()
         cursor.execute(sql)
       return cursor
    #

    #
    db = DB()
    sql = &quot;SELECT bla FROM foo&quot;
    data = db.query(sql)

    for row in data:
        do_something(row)
    #

But I&#39;m always getting this:

    #
    Traceback (most recent call last):
      File &quot;teste.py&quot;, line 124, in &lt;module&gt;
       run()
     File &quot;teste.py&quot;, line 109, in run
       for row in data:
     File &quot;/usr/lib64/python2.5/site-packages/MySQLdb/cursors.py&quot;, line 417, in next
       row = self.fetchone()
     File &quot;/usr/lib64/python2.5/site-packages/MySQLdb/cursors.py&quot;, line 388, in fetchone
       r = self._fetch_row(1)
     File &quot;/usr/lib64/python2.5/site-packages/MySQLdb/cursors.py&quot;, line 285, in _fetch_row
       return self._result.fetch_row(size, self._fetch_type)
       _mysql_exceptions.OperationalError: (2013, &#39;Lost connection to MySQL server during query&#39;)
        Exception _mysql_exceptions.OperationalError: (2013, &#39;Lost connection to MySQL server during query&#39;) in &lt;bound method SSCursor.__del__ of &lt;MySQLdb.cursors.SSCursor object at 0x7f7e3c8da410&gt;&gt; ignored
    #

Do you have any idea?

Lost connection to MySQL server during query

What&#39;s the difference between VARCHAR and CHAR in MySQL?

I am trying to store MD5 hashes.

What&#39;s the difference between VARCHAR and CHAR?

Is it posible to duplicate an entire MySQL database on a linux server?

I know I can use export and import but the original database is &gt;25MB so that&#39;s not ideal.

Is it possible using mysqldump or by directly duplicates the database files?

Duplicate Entire MySQL Database

I am running this query on MySQL

    SELECT ID FROM (
        SELECT ID, msisdn
        FROM (
            SELECT * FROM TT2
        )
    );

and it is giving this error:

&gt; Every derived table must have its own alias. 

What&#39;s causing this error?

What is the error &quot;Every derived table must have its own alias&quot; in MySQL?

What is the MySQL command to retrieve the count of records in a table?

Count table rows

in **SQL Server** is possible to execute a SELECT, without reference to a table; something like:

    Select 1.2 +3, &#39;my dummy string&#39;

As **Oracle** does not allow a SELECT without a FROM, I use the dual table for this type of operation; something like:

    Select 1,2+3, &#39;my dummy string&#39; FROM DUAL

There is a better way of doing this type of query? it is good practice to use the dual table?

Select without a FROM clause in Oracle

We have a few *huge* databases (20GB+) which mostly contain static lookup data.  Because our application executes joins against tables in these databases, they have to be part of each developers local SQL Server (i.e. they can&#39;t be hosted on a central, shared database server).  

We plan on copying a canonical set of the actual SQL Server database files (*.mdf and *.ldf) and attach them to each developer&#39;s local database.

What&#39;s the best way to find out the local SQL Server instance&#39;s data directory so we can copy the files to the right place?  This will be done via an automated process, so I have to be able to find and use it from a build script.

How do I find the data directory for a SQL Server instance?

I have the following table:

    CREATE TABLE child( 
      id INTEGER PRIMARY KEY, 
      parent_id INTEGER, 
      description TEXT);

How do I add a foreign key constraint on `parent_id`? Assume foreign keys are enabled.

Most examples assume you&#39;re creating the table - I&#39;d like to add the constraint to an existing one.



How do I add a foreign key to an existing SQLite table?

I am looking for a `where` clause that can be used to retrieve records for the last 24 hours?

How to select records from last 24 hours using SQL?

In Perl I can repeat a character multiple times using the syntax:

    $a = &quot;a&quot; x 10; // results in &quot;aaaaaaaaaa&quot;

Is there a simple way to accomplish this in Javascript? I can obviously use a function, but I was wondering if there was any built in approach, or some other clever technique.

Repeat a string in JavaScript a number of times

How do I implement the following (Python pseudocode) in C++?

    if argv[1].startswith(&#39;--foo=&#39;):
        foo_value = int(argv[1][len(&#39;--foo=&#39;):])

(For example, if `argv[1]` is `--foo=98`, then `foo_value` is `98`.)

**Update:** I&#39;m hesitant to look into Boost, since I&#39;m just looking at making a very small change to a simple little command-line tool (I&#39;d rather not have to learn how to link in and use Boost for a minor change).


How do I check if a C++ std::string starts with a certain string, and convert a substring to an int?

I need to write a unit test for a method that takes a stream which comes from a text file. I would like to do do something like this:

    Stream s = GenerateStreamFromString(&quot;a,b \n c,d&quot;);


How do I generate a stream from a string?

Consider this code:

    String first = &quot;abc&quot;; 
    String second = new String(&quot;abc&quot;);

When using the `new` keyword, Java will create the `abc` `String` again right?
Will this be stored on the regular heap or the `String` pool?
How many `String`s will end in the `String` pool?

Questions about Java&#39;s String pool

This seems like it should be pretty trivial, but I am new at Python and want to do it the most Pythonic way.

I want to find the index corresponding to the n&#39;th occurrence of a substring within a string.

There&#39;s got to be something equivalent to what I WANT to do which is 

`mystring.find(&quot;substring&quot;, 2nd)`

How can you achieve this in Python?



Find the nth occurrence of substring in a string

What is the correct SQL syntax to insert a value with an apostrophe in it?

    Insert into Person
      (First, Last)
    Values
      &#39;Joe&#39;,
      &#39;O&#39;Brien&#39;

I keep getting an error as I think the apostrophe after the O is the ending tag for the value.


How to insert a value that contains an apostrophe (single quote)?

I have made this code for giving out +1 point, but it doesn&#39;t work properly.

    mysql_query(&quot;
        UPDATE member_profile 
        SET points= &#39; &quot;.$points.&quot; &#39; + 1 
        WHERE user_id = &#39;&quot;.$userid.&quot;&#39;
    &quot;);

The `$points` variable is the user&#39;s points right now. I want it to add one to it. So example if he had like 5 points, it should be 5+1 = 6, but it doesn&#39;t, it just changes to 1.

What have I done wrong?


Increment value in MySQL update query

In **SQL Server**, it is possible to insert rows into a table with an `INSERT.. SELECT` statement:

    INSERT INTO Table (col1, col2, col3)
    SELECT col1, col2, col3 
    FROM other_table 
    WHERE sql = &#39;cool&#39;

Is it also possible to _update_ a table with `SELECT`? I have a temporary table containing the values and would like to update another table using those values. Perhaps something like this:

    UPDATE Table SET col1, col2
    SELECT col1, col2 
    FROM other_table 
    WHERE sql = &#39;cool&#39;
    WHERE Table.id = other_table.id


How do I UPDATE from a SELECT in SQL Server?

I&#39;m trying to update a field in the database to the sum of its joined values:

    UPDATE P
    SET extrasPrice = SUM(E.price)
    FROM dbo.BookingPitchExtras AS E
    INNER JOIN dbo.BookingPitches AS P ON E.pitchID = P.ID
        AND P.bookingID = 1
    WHERE E.[required] = 1

When I run this I get the following error:

    &quot;An aggregate may not appear in the set list of an UPDATE statement.&quot;

Any ideas?

SQL Update to the SUM of its joined values

I have two tables:

    A [ID, column1, column2, column3]
    B [ID, column1, column2, column3, column4]

`A` will always be subset of `B` (meaning all columns of `A` are also in `B`).

I want to update a record with a specific `ID` in `B` with their data from `A` for all columns of `A`. This `ID` exists both in `A` and `B`.

Is there an `UPDATE` syntax or any other way to do that without specifying the column names, just saying *&quot;set all columns of A&quot;*?

I&#39;m using PostgreSQL, so a specific non-standard command is also accepted (however, not preferred).

Content Type	Original Author	Original Content on Stackoverflow
Question	n00b0101	View Question on Stackoverflow
Solution 1 - Mysql	Kaleb Brasee	View Answer on Stackoverflow
Solution 2 - Mysql	Tatu Ulmanen	View Answer on Stackoverflow
Solution 3 - Mysql	Bernard Chen	View Answer on Stackoverflow
Solution 4 - Mysql	Lukas	View Answer on Stackoverflow

MySql - Way to update portion of a string?

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Solution 3 - Mysql

Solution 4 - Mysql

How to use web-fonts legally?

The infamous java.sql.SQLException: No suitable driver found

Attributions