How to get pure String value from SQL format in IntelliJ?

Question

I am using Spring Jpa to write the SQL query the IntelliJ supports me to reformat SQL easy to read. However when I try to copy this SQL to run in the database it has a lot of redundant characters I need to remove such as +  
. How can I do for copying only the value of this query?

Brahma Prakash Shukla · Answer

If you want to copy only the value of the SQL query without any redundant characters you can follow these steps: Open the SQL query in IntelliJ. Select the entire SQL query. Press Ctrl + Alt + Shift + T (or right-click and go to Refactor -> Copy as Plain Text). Paste the copied text into a text editor like Notepad or Sublime Text. Manually remove any redundant characters such as +  or 
 from the copied text. Copy the cleaned SQL query from the text editor and use it in your database. By using the Copy as Plain Text feature you can avoid including any formatting or unnecessary characters introduced by IntelliJ and focus only on the actual SQL query.

Deepak Rawat · Answer

If you want to copy only the value of the SQL query generated by Spring JPA without any extra characters such as concatenation operators (+) or line breaks (
) you can try the following steps: Retrieve the SQL query generated by Spring JPA in your code. This might be done by enabling the logging of SQL queries or by using debugging techniques. Instead of directly copying the formatted SQL query from IntelliJ extract the query string programmatically from your code. Remove any unnecessary characters or formatting before copying the query. You can use string manipulation functions to achieve this. Copy the modified query and use it in your database. Here's a simple example in Java to demonstrate this process: import org.springframework.data.jpa.repository.Query; import org.springframework.stereotype.Repository; @Repository public interface MyRepository extends JpaRepository { @Query(SELECT column1 column2 FROM MyEntity WHERE column3 = 'value') List getResults(); } // In your code where you want to retrieve and modify the SQL query List results = myRepository.getResults(); String sqlQuery = ((org.hibernate.jpa.Query) results).getHibernateQuery().getQueryString(); // Remove unnecessary characters String cleanedQuery = sqlQuery.replace(+ ).replace(\ ).replace(
 ); // Now you can copy the cleanedQuery and use it in your database System.out.println(cleanedQuery); extracting and modifying the SQL query you can obtain a clean and ready-to-use version without the redundant characters making it easier to run the query in your database.

Rajkiran Swain · Answer

Select the SQL query code in your IntelliJ editor that you want to copy. Right-click on the selected code and choose the Copy option or press Ctrl+C (Command+C on macOS) to copy the code to the clipboard. Open a text editor or any other text processing tool of your choice. Paste the copied SQL query into the text editor by right-clicking and selecting the Paste option or pressing Ctrl+V (Command+V on macOS). Use the text editor's find and replace functionality to remove the redundant characters. For example: To remove the + character you can use the find and replace feature to replace + with an empty string. To remove the  character you can use the find and replace feature to replace  with an empty string. To remove the newline character (
) you can use the find and replace feature to replace 
 with an empty string. After performing the necessary find and replace operations you will have the pure string value of the SQL query without the redundant characters. Copy the cleaned SQL query from the text editor and use it as needed such as running it in the database.

Anandu G Nath · Answer

Using SQL Functions Assuming you have a date in SQL format and you want to extract the date as a string: SELECT DATE_FORMAT(Date_Column '%Y-%m-%d') AS pure_String FROM Dummy_table; Using String Functions: You can also use string manipulation functions available in your SQL database to extract or modify string values. SELECT SUBSTRING(Date_column start_index length) AS pure_string FROM Dummy_table;