A standalone tool from Red Gate, that enables quick search for SQL across databases.
Questions tagged [sql-search]
11 questions
1
vote
2 answers
PHP searching from fixed rows
I have patient table with 1000+ patient records. All records are created by 5 admins. I have separated patients in patient table using admin_id column. When admin "A" login then he only can see those patient that created by him. Now i wanna search…
Fahim Amin
- 17
- 4
1
vote
1 answer
JetBrains DataGrip search utility
Is it possible to search a specific string (e.g. table name) in JetBrains DataGrip?
I'm looking for something like Red Gate's SQL Search
Adam
- 161
- 2
- 8
1
vote
1 answer
SQL "like" search for characters like "öüä"?
In database fields are characters to html entities converted, so if I try to search for words like übung or ärzte nothing is found. I tried to add in my SQL query COLLATE utf8_general_ci but I get there following error: COLLATION 'utf8_general_ci'…
nowilius
- 131
- 1
- 13
0
votes
2 answers
Find the column(s) with values which has special characters using SQL
I have some tables in a DB as mentioned below.,
**Table1**
+-------+--------------+-------------+
|**ID** |**Name** |**Country** |
+-------+--------------+-------------+
| 1 |Avinash Kumar |India |
| 2 |Sat!sh@S |USA …
Akhil
- 41
- 3
- 10
0
votes
2 answers
MySQL conditional search query
I am trying to get all the co-authors of an author. The first column is the id of a publication. The next three columns are the first, middle and last names of an author.
4 KARL K KWON
4 JACK A SMITH
4 DINESH SMITH
5 KARL K KWON
5 JACK B…
Dinesh
- 2,194
- 3
- 30
- 52
0
votes
2 answers
Create links from String results after SQL search
I have successfuly searched my DB table for what i want and passed it into a DataTable (dt).
The idea is that i want (after the search) to redirect someone to the result page he likes.
So if he Searches for example "Michael" , i'd like to show him…
frcake
- 229
- 1
- 3
- 18
0
votes
1 answer
Can I search for multiple words using RedGate's SQL Search?
I want to do this:
I know I can search for an exact match for one word but I want to be able to search for multiple words in the same object. Is that possible?
JJ.
- 9,580
- 37
- 116
- 189
-1
votes
1 answer
T-SQL Order by most relevant and most recent on top
I am using ContainsTable in my T-SQL statement to get most relevant content as per some given keywords in below query.
Select @Values = '"Keyword 1","Keyword 2,"Keyword 3"',
Select @FirstLevelValues = 'Isabout ('+@Values+' Weight(0.7))'
Select…
Cyberpks
- 1,401
- 6
- 21
- 51
-1
votes
1 answer
How to using LIKE operator which data saved in variable?
I need to search data in the database table.
I save data in a variable, then I want to display the data using it LIKE an operator when the data is called.
This is my code :
$data_input_user = $inFilter;
$data_input_user =…
zordon_tri
- 3
- 3
-1
votes
1 answer
MySql search for string in column 'X' and insert string in column 'Y'
I am very new to MySql and I am having a lot of trouble with the syntax. I am looking for a query that will do the following.
if string 'abc' is present in any row of column 'X', then insert string 'def' into column 'Y', only in the same rows that…
bigman8923
- 9
- 1
-5
votes
1 answer
SQL Search query Result
SQL select attract but query I want to give the results as follows.
Select * from table where ???? Result
BuuRoCk
- 79
- 1
- 1
- 10