How to quickly add single quotation marks and single quotation marks to SQL search conditions using the NotePad ++ recording macro function?

How to quickly add single quotation marks and single quotation marks to SQL search conditions using the NotePad ++ recording macro function?

When many of our documents need to be searched for information, the following statement is often used:

 SELECT * FROM Member WHERE accunt in ( 'Tom', 'John', 'May' )

IN the search condition of the preceding statement IN, there are Tom, John, and May. If the amount of data is small, you can also add a simple example and a funny background in the front and back of the notebook. However, when you encounter a situation where you want to check 50 screenshots at a time, it may take a lot of time for the inbound traffic from one hour to one hour.
In the past, I used the CONCATENATE function in Excel to handle such information. However, one day my colleague taught me how to use the NotePad ++ collection function to complete this task.

I think this method is faster than Excel processing, so I 'd like to share it here.

1. the search criteria to be processed will be sent to NotePad ++. In the following example, there are 25 records (the English name in this example is the checklist obtained from google Images)

2. because a huge set is used to download your operations, you should first move the game tag to the starting position of the first item, then, press the set in the NotePad ++ tool column to start logging.

3. because the game standard is already at the forefront, that is, the position of the first item, please directly use the website, sort in the following sort orders in the sort order (in the following example, all of them are sorted by sort)

「 '→ 「 End 」 → 「, 」 → 「 success 」 → 「 Home 」

4. after completing step 3, it should be changed to the following category. In the first category, the search criteria have been added to the previous and subsequent orders, and the last comment has been added.

5. Confirm Step 4. Click "" to select the"

6. After the renewal, the remaining 24 resources will be able to be processed by using the collection. Run the operation once to check whether the operation is normal.

Click to select the next-generation pay-as-you-go video collection (the game is still at the starting position of the second-generation resource at this time ~)

7. After playing the huge set, you can see that the second item has been handled, and the game tag has moved to the starting position of the third item.

8. After the certificate collection is complete, let the collection collect the latest data.

Click "repeat" next to Step 1 to repeat the huge line set. Then, in the prompt window, select "Upload row to the end of the file", and then press "OK ".

9. after the marker line is completed, you can see that all the conditions have been added to the previous and subsequent simple examples, but note that the last example of the search condition, there will be a joke at the end

Remember to skip this joke and try again in the SQL statement. Otherwise, check whether it will cause loss ~

(When the ignore row is completed, the dialog box in the duplicate rows for a large set does not automatically close the page. You can cancel the operation at this time)

10. After completing the above steps, the requirement has been met. However, if you are concerned about using NotePad ++ at this time, you will need to renew the collection again next time.

Fortunately, NotePad ++ provides the function of storing huge collections, so we can save this huge collection and use it directly next time.

Click "Press next" in step 1 to open the memory window of the master set. In the "Name" field, set a Name for the master set, then, press OK and then press confirm.

11. at this time, the NotePad ++ will be connected, and then the website will be opened and the unprocessed resources will be retained, click "repeat a huge number of rows" to select a large number of databases in the dialog box.

Select the huge collections saved by the primary keys, then select the primary keys row to the end of the file, and then press the primary row, now we can see the result after processing as in step 9 ~