`Search-&gt;File` menu (also accessible using `Ctrl+H`, then navigate to `File` tab), enter the text to search for, hit the `Replace...` button which will give you another dialog where you can replace text.

I want to use order by with union in mysql query.
I am fetching different types of record based on different criteria from a table based on distance for a search on my site.
The first select query returns data related to the exact place search .
The 2nd select query returns data related to distance within 5 kms from the place searched.
The 3rd select query returns data related to distance within 5-15 kms from the place searched.

Then i m using union to merge all results and show on a page with paging. Under appropriate heading as **&#39;Exact search results&#39;**, **&#39;Results within 5 kms&#39;** etc

Now i want to sort results based on id or add_date. But when i add order by clause at the end of my query ( query1 union query 2 union query 3 order by add_date). It sorts all results. But what i want is it should sort under each heading.

Using union and order by clause in mysql

I am trying to write a query that will check if a specific table in MySQL has a specific column, and if not —&#160;create it. Otherwise do nothing. This is really an easy procedure in any enterprise-class database, yet MySQL seems to be an exception.

I thought something like

    IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS 
               WHERE TABLE_NAME=&#39;prefix_topic&#39; AND column_name=&#39;topic_last_update&#39;) 
    BEGIN 
    ALTER TABLE `prefix_topic` ADD `topic_last_update` DATETIME NOT NULL;
    UPDATE `prefix_topic` SET `topic_last_update` = `topic_date_add`;
    END;

would work, but it fails badly. Is there a way?


MySQL, Check if a column exists in a table with SQL

I&#39;m trying to do a find and replace over many files within an Eclipse project, but I can&#39;t seem to find a way to do it. Googling showed me that there are plug-ins that can accomplish this, but is there any built-in functionality in Eclipse? (It seems to be a pretty basic task; it&#39;s surprising me that I can&#39;t find a way to do it.)

Is there a way to find/replace across an entire project in Eclipse?

<p>I'm trying to do a find and replace over many files within an Eclipse project, but I can't seem to find a way to do it. Googling showed me that there are plug-ins that can accomplish this, but is there any built-in functionality in Eclipse? (It seems to be a pretty basic task; it's surprising me that I can't find a way to do it.)</p>


I am using the Android plugin for Eclipse, and when I try to run my program using a real device through the *Android Device Chooser*, my phone is not listed as a device. I have updated Eclipse, all of the Android packages, and the USB driver, but it still isn&#39;t showing up. My phone is running Android 2.1, which is also the target version listed in the Eclipse project.

Also it happens that the device shows up as an unknown target and the serial number as question marks as shown in the screenshot.

![Android Device Chooser][1]


  [1]: http://i.stack.imgur.com/9Zl6F.jpg

Why is Eclipse&#39;s Android Device Chooser not showing my Android device?

In eclipse, when your cursor is placed on a method (or other things), other places the method exists are highlighted. I&#39;d like to change the color of this highlight, but after scouring the eclipse preferences many times in all 3 places, I have yet to find it.

Any of you `Eclipse` gurus know where to find this option?

Eclipse: How do you change the highlight color of the currently selected method/expression?

Some days ago my Eclipse was working fine and a +/- appeared in every block that could be collapsed (functions, classes, etc.)... but now it does appear, and I don&#39;t know how to activate that feature again.

It&#39;s Eclipse Helios, running on a Gentoo Linux box.

How to collapse blocks of code in Eclipse?

I generally have my working projects sitting on folders on my Desktop. When they are completed I just move them to a `c:\dev\`. The thing is I&#39;m doing it in a rather archaic way.

    1. move project files
    2. delete project on Eclipse
    3. create new project on Eclipse on the new location

How to you guys move projects around?

If I could alter the: *File -&gt; Properties -&gt; Resource -&gt; Location* path it would be dead simple!

**Example move:**

    c:\user\desktop\project_123
    c:\dev\project_123




Moving project to another folder in Eclipse


You know how in Eclipse&#39;s Preferences window (menu bar:  Window --&gt; Preferences), you have a hierarchy to browse, but you also have a text search field.  And as you type into that search field, the hierarchy is filtered to show only entries matching what you typed?

I would love to see the same feature in the Package Explorer tab.
I have 100s of files in my Package Explorer hierarchy.  Oftentimes I just want to type in a partial name, and see only those matching entries.

Does this feature exist?  Something related, that would accomplish the same goal?  (search, not browse)?

Thanks

In Eclipse, in the package explorer, can I find files by name?

I have a C# solution with two projects: a service (the main project) and a logger. The service uses classes from the logger. I&#39;ve added a Reference to the logger project within the service project. At design time, autocomplete works fine: the logger&#39;s classes are visible, references that I use are colored appropriately.

I Rebuild the solution, and things go wrong. The references are no longer recognized: &quot;The name &#39;Logging&#39; does not exist in the current context&#39; and the classes no longer exist in autocomplete. Removing and reattaching the reference gets me back to the base state of having the identifiers visible to autocomplete.

I&#39;ve rebooted, cleared all caches, made sure this is the only instance of VS 2010 running on my machine.

Is there something obvious (obviously) that I&#39;m missing?

Referenced Project gets &quot;lost&quot; at Compile Time

Task is to form Visual Studio 2010 project so, that during any build or publish some `foo.exe` utility should be copied to output (`bin`) directory.  

Early I have made PostBuildEvent task in .csproj (MSBuild-file):

    &lt;PropertyGroup&gt;
      &lt;PostBuildEvent&gt;
        Copy &quot;$(SolutionDir)Tools\foo.exe&quot; &quot;$(ProjectDir)$(OutDir)foo.exe&quot;
      &lt;/PostBuildEvent&gt;
    &lt;/PropertyGroup&gt;
 

But this is not universal. During publishing (Visual Studio 2010) `foo.exe` appears in `bin` directory, but is not copied to output publish directory. Maybe I do everything completely wrong and there is standard mechanism to include files in projects to be later, during build or publish, copied to `bin`?


VS2010 How to include files in project, to copy them to build output directory automatically during build or publish

I&#39;ve installed NetBeans 6.9.1 and installed few updates for it.

Then I&#39;ve created a new project from existing sources. After a few changes I&#39;ve closed it. And now I am having an error, when trying to open a new project from existing sources (the same files):

&gt; Sources directory is already netbeans project (maybe only in memory).

After Googling it, I noticed it happened not only with me. But I didn&#39;t find the correct solution. I&#39;ve tried to restart the IDE, I&#39;ve tried to restart the PC, I&#39;ve tried to reinstall NetBeans. Nothing helped.


&quot;Sources directory is already netbeans project&quot; error when opening a project from existing sources

As I was writing up this question I managed to solve it so repeat it here for the benefit of others. Here is the initial problem:

I have created a very simple library project which I want to reference in another project. I have done this previously with no problems so not really sure why it is not working this time. I have:

 1. Flagged the library project via project properties. The `default.properties` file has this set : `android.library=true`

 2. In my other project added reference to my library project via project properties. The `default.properties` file has the reference added as expected ie `android.library.reference.1=K:/android_test_ws/applicationRegistrar`

 3. The green tick against the referenced library project starts off green and then changes to a red cross.

This implies that there must be something wrong / missing from the library project but I don&#39;t know what. My library project on this occasion is MUCH simpler than the previous one I created.

In eclipse, unable to reference an android library project in another android project

Usually a C# project has a .csproj file associated with it. What is that file for? What data does it contain? 

What does the .csproj file do?

I am looking to replace values in a particular column. For example the following column values

    column name
    ----------
    Test1
    Test2
    Test3
    Test12

should be (replacing `est1` with `rest1`)

    column name
    ----------
    Trest1
    Test2
    Test3
    Trest12


How to replace specific values in a oracle database column?

    var str   = &#39;asd-0.testing&#39;;
    var regex = /asd-(\d)\.\w+/;

    str.replace(regex, 1);

That replaces the entire string `str` with `1`. I want it to replace the matched substring instead of the whole string. Is this possible in Javascript?

How can I replace a regex substring match in Javascript?

How to search for occurrences of more than one space between words in a line

```none
1. this is a line containing  2 spaces
2. this is a line containing   3 spaces
3. this is a line containing multiple spaces first  second   three   four
```

All the above are valid matches for this regex. What regex should I use?


How to search for occurrences of more than one space between words in a line

Anyone know of a very fast way to replace the last occurrence of a string with another string in a string?

Note, **the last occurrence of the string might not be the last characters in the string.**

Example:

    $search = &#39;The&#39;;
    $replace = &#39;A&#39;;
    $subject = &#39;The Quick Brown Fox Jumps Over The Lazy Dog&#39;;

Expected Output:

    The Quick Brown Fox Jumps Over A Lazy Dog

Replace last occurrence of a string in a string

I have a file (more specifically, a log4j configuration file) and I want to be able to read in the file and pick out certain lines in the code and replace them. For example, within the file there is a string of text that indicates the directory it is stored in, or the level of the logger. I want to be able to replace those string of text without reading in the file, writing it to another file, and deleting the original file. Is there a more efficient way of doing find and replace texts in a file using Java?

Here is an example of the text file I&#39;m trying to work with:

    log4j.rootLogger=DEBUG, A0
    
    log4j.appender.A0=org.apache.log4j.RollingFileAppender
    log4j.appender.A0.File=C:/log.txt
    log4j.appender.A0.MaxFileSize=100KB
    log4j.appender.A0.MaxBackupIndex=1
    
    log4j.appender.A0.layout=org.apache.log4j.RollingFileAppender
    log4j.appender.A0.layout.ConversionPattern=%-4r [%t] %-5p: %c %x - %m%n

I want to be able to read the file and replace &#39;DEBUG&#39; with another level or replace the file directory name &#39;C:/log.txt&#39;. The log configuration file is also written in xml. An example of that is featured below.

    &lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot; standalone=&quot;no&quot;?&gt;
    &lt;!DOCTYPE log4j:configuration SYSTEM &quot;log4j.dtd&quot;&gt;
    &lt;log4j:configuration&gt;
        &lt;appender class=&quot;org.apache.log4j.RollingFileAppender&quot; name=&quot;A0&quot;&gt;
            &lt;param name=&quot;append&quot; value=&quot;false&quot;/&gt;
            &lt;param name=&quot;File&quot; value=&quot;C:/log/.txt&quot;/&gt;
            &lt;param name=&quot;MaxBackupIndex&quot; value=&quot;1&quot;/&gt;
            &lt;param name=&quot;MaxFileSize&quot; value=&quot;100KB&quot;/&gt;
            &lt;layout class=&quot;org.apache.log4j.PatternLayout&quot;&gt;
                &lt;param name=&quot;ConversionPattern&quot; value=&quot;%-4r [%t] %-5p: %c %x - %m%n&quot;/&gt;
            &lt;/layout&gt;
        &lt;/appender&gt;
        &lt;root&gt;
            &lt;level value=&quot;DEBUG&quot;/&gt;
            &lt;appender-ref ref=&quot;A0&quot;/&gt;
        &lt;/root&gt;
    &lt;/log4j:configuration&gt;

I&#39;m thinking it may be possible to use a hash map for this type of implementation? 

Content Type	Original Author	Original Content on Stackoverflow
Question	froadie	View Question on Stackoverflow
Solution 1 - Eclipse	nos	View Answer on Stackoverflow

Is there a way to find/replace across an entire project in Eclipse?

Eclipse Problem Overview

Eclipse Solutions

Solution 1 - Eclipse

MySQL, Check if a column exists in a table with SQL

Using union and order by clause in mysql

Attributions