    UPDATE urls
    SET url = REPLACE(url, &#39;domain1.com/images/&#39;, &#39;domain2.com/otherfolder/&#39;)

    UPDATE yourtable
    SET url = REPLACE(url, &#39;http://domain1.com/images/&#39;, &#39;http://domain2.com/otherfolder/&#39;)
    WHERE url LIKE (&#39;http://domain1.com/images/%&#39;);

relevant docs: http://dev.mysql.com/doc/refman/5.5/en/string-functions.html#function_replace

Try using the [REPLACE function][1]:

    mysql&gt; SELECT REPLACE(&#39;www.mysql.com&#39;, &#39;w&#39;, &#39;Ww&#39;);
            -&gt; &#39;WwWwWw.mysql.com&#39;

Note that it is case sensitive.

  [1]: http://dev.mysql.com/doc/refman/5.5/en/string-functions.html#function_replace

Try this...

    update [table_name] set [field_name] = 
    replace([field_name],&#39;[string_to_find]&#39;,&#39;[string_to_replace]&#39;);

You need the **WHERE** clause to replace **ONLY** the records that complies with the condition in the WHERE clause (as opposed to all records). You use **%** sign to indicate partial string: I.E.

    LIKE (&#39;...//domain1.com/images/%&#39;);

means all records that **BEGIN** with `&quot;...//domain1.com/images/&quot;` and have anything AFTER (that&#39;s the `%` for...)

Another example:

    LIKE (&#39;%http://domain1.com/images/%&#39;)

which means all records that contains `&quot;http://domain1.com/images/&quot;`

in any part of the string...


**First, have to check**

    SELECT * FROM `university` WHERE course_name LIKE &#39;%&amp;amp%&#39;

**Next, have to update**

    UPDATE university
    SET course_name = REPLACE(course_name, &#39;&amp;amp&#39;, &#39;&amp;&#39;) WHERE id = 1

**Results:** Engineering &amp;amp Technology =&gt; **Engineering &amp; Technology**

Most operations in `pandas` can be accomplished with operator chaining (`groupby`, `aggregate`, `apply`, etc), but the only way I&#39;ve found to filter rows is via normal bracket indexing

    df_filtered = df[df[&#39;column&#39;] == value]

This is unappealing as it requires I assign `df` to a variable before being able to filter on its values.  Is there something more like the following?

    df_filtered = df.mask(lambda x: x[&#39;column&#39;] == value)

pandas: filter rows of DataFrame with operator chaining

For use in express.js environments. Any suggestions?


How to set NODE_ENV to production/development in OS X

I have a table with the following columns in a MySQL database

    [id, url]

And the urls are like:  

     http://domain1.com/images/img1.jpg

I want to update all the urls to another domain

     http://domain2.com/otherfolder/img1.jpg

keeping the name of the file as is. 

What&#39;s the query must I run?

Update a column value, replacing part of a string

I have a table with the following columns in a MySQL database
<pre><code class="hljs language-bash">[id, url]
</code></pre>
And the urls are like:
<pre><code class="hljs language-bash"> http://domain1.com/images/img1.jpg
</code></pre>
I want to update all the urls to another domain
<pre><code class="hljs language-bash"> http://domain2.com/otherfolder/img1.jpg
</code></pre>
keeping the name of the file as is.
What's the query must I run?

I have a column that is currently `varchar(100)` and I want to make it `10000`.

is it as simple as 

    alter table table_name set column col_name varchar (10000);

I am afraid to corrupt the exiting data. Will I be ok if I run this query? Or should I do I `alter` the column another way?

Thanks!

MySQL - How to increase varchar size of an existing column in a database without breaking existing data?

Is there a way to retrieve SQL result column value using column name instead of column index in Python? I&#39;m using Python 3 with mySQL. The syntax I&#39;m looking for is pretty much like the Java construct:

    Object id = rs.get(&quot;CUSTOMER_ID&quot;); 

I&#39;ve a table with quite a number of columns and it is a real pain to constantly work out the index for each column I need to access. Furthermore the index is making my code hard to read.

Thanks!

How to retrieve SQL result column value using column name in Python?

This has probably been asked before, but I&#39;m unable to make my way through the myriad of search results.

Given a non-normalized MySQL table, what is the most optimized query to count the number of times each distinct value of column x was used?

e.g. Given a table containing

    mike
    mary
    mike

Return results like:

    mike 2
    mary 1

From the MySQL documentation, it would seem that `count` is an aggregate function that can be used with `GROUP BY`, but it&#39;s not doing what I want (it&#39;s returning the total number of rows in the `GROUP BY`, not the number of appearances for each row. i.e. this does not work `SELECT count(email) as c FROM orders GROUP BY email`

Count number of times value appears in particular column in MySQL

I am planning to store a `json_encoded` string on my database. I can&#39;t precisely tell the length its going to be, but I&#39;m pretty sure it will be long. My concern is which field type I am going to use for this, is it `blob` or `text`?

I prefer the one where I can save space as much as possible over fast searching, in any case I have other column where I should just index.

Should I use blob or text for JSON in MySQL?

Which of the following options, if any, is considered best practice when designing a table used to store user settings? 

(OPTION 1)

    USER_SETTINGS
    -Id
    -Code (example &quot;Email_LimitMax&quot;)
    -Value (example &quot;5&quot;)
    -UserId

(OPTION 2) 

create a new table for each setting where, for example, notification settings would require you to create:

    &quot;USER_ALERT_SETTINGS&quot;
    -Id
    -UserId
    -EmailAdded (i.e true)
    -EmailRemoved 
    -PasswordChanged
    ...
    ...

    &quot;USER_EMAIL_SETTINGS&quot;
    -Id
    -UserId
    -EmailLimitMax
    ....

(OPTION 3)

    &quot;USER&quot;
    -Name
    ...
    -ConfigXML


Database design for user settings

I&#39;m trying to get it to display the number of employees that are hired after June 20, 1994,

    Select employee_id, count(*)
    From Employee
    Where to_char(employee_date_hired, &#39;DD-MON-YY&#39;) &gt; 31-DEC-95; 

But I get an error saying 

&gt; &quot;JUN&#39; invalid identifier. 

Please help, thanks!



Comparing Dates in Oracle SQL

&gt; **Possible Duplicate:**  
&gt; [How to make a varchar2 field shorter in Oracle?](https://stackoverflow.com/questions/8404194/how-to-make-a-varchar2-field-shorter-in-oracle)  

&lt;!-- End of automatically inserted text --&gt;

In Oracle(9i and above)

     Alter table employee  
     MODIFY ename varchar2(10);

I want to alter the column ename of table employee from varchar2(30) to varchar2(10)
  
 - Case1 : if the table has data having ename column containing values which are of length less than 10 char(i mean it can fit in varchar2(10) comfortably) - is this allowed by oracle ?

 - Case 2: if the table has data having ename column containing values which are of length greater than 10 char(i mean it can not fit in varchar2(10)) - is this not allowed by oracle ?

alter the size of column in table containing data

I&#39;m trying to join 3 tables in a view; here is the situation:

I have a table that contains information of students who are applying to live on this College Campus. I have another table that lists the Hall Preferences (3 of them) for each Student. But each of these preferences are merely an ID Number, and the ID Number has a corresponding Hall Name in a third table (did not design this database...).

Pretty much, I have `INNER JOIN` on the table with their preferences, and their information, the result is something like...

     John Doe | 923423 | Incoming Student | 005

Where `005` would be the `HallID`. So Now I want to match that `HallID` to a third table, where this table contains a `HallID` and `HallName`.

So pretty much, I want my result to be like...

     John Doe | 923423 | Incoming Student | Foley Hall &lt;---(INSTEAD OF 005)

Here is what I currently have:

    SELECT
      s.StudentID, s.FName, 
      s.LName, s.Gender, s.BirthDate, s.Email, 
      r.HallPref1, r.HallPref2, r.HallPref3
    FROM
      dbo.StudentSignUp AS s 
      INNER JOIN RoomSignUp.dbo.Incoming_Applications_Current AS r 
        ON s.StudentID = r.StudentID 
      INNER JOIN HallData.dbo.Halls AS h 
        ON r.HallPref1 = h.HallID

SQL Inner-join with 3 tables?

I have this, and i get an error at set total.
Why can&#39;t i access a cte many times?

    ALTER PROCEDURE [dbo].[GetLeaguePlayers]
    (
    	@idleague int,
    	@pageNumber int,
    	@pageSize int,
    	@total int OUTPUT
    )
    AS
    WITH CTEPlayers AS
    (
    	SELECT ROW_NUMBER() OVER (ORDER BY p.Name) AS RowNumber, p.Id, p.Name, t.Name AS Team
    	FROM Players p INNER JOIN Teams t ON p.IdTeam=t.Id INNER JOIN Leagues l ON l.Id=t.IdLeague
    	WHERE l.Id=@idleague
    )
    SELECT Id, Name
    FROM CTEPlayers c
    WHERE RowNumber&gt;@pageSize*(@pageNumber-1) AND RowNumber&lt;@pageSize*@pageNumber;
    SET @total = ( SELECT COUNT(*) FROM CTEPlayers )

Use one CTE many times

I have a table that has 20 integer columns and 1 text column named &#39;foo&#39;

If I run query:

    SELECT * from table_name where foo is NULL

I get error:

    ERROR:  column &quot;foo&quot; does not exist

I have checked myself that his column indeed exists. If I do something like:

    SELECT * from table_name where count is NULL

The resulting output shows &#39;foo&#39; as one of the columns....
I am guessing I have to do something special in the query because foo is a text column...

Thanks for the help (POSTGRESQL 8.3)

Content Type	Original Author	Original Content on Stackoverflow
Question	Addev	View Question on Stackoverflow
Solution 1 - Mysql	Dmytro Shevchenko	View Answer on Stackoverflow
Solution 2 - Mysql	Marc B	View Answer on Stackoverflow
Solution 3 - Mysql	schellack	View Answer on Stackoverflow
Solution 4 - Mysql	ManiMaran A	View Answer on Stackoverflow
Solution 5 - Mysql	Kenneth Daly	View Answer on Stackoverflow
Solution 6 - Mysql	Solomon Suraj	View Answer on Stackoverflow

Update a column value, replacing part of a string

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Solution 3 - Mysql

Solution 4 - Mysql

Solution 5 - Mysql

Solution 6 - Mysql

How to set NODE_ENV to production/development in OS X

pandas: filter rows of DataFrame with operator chaining

Attributions