SQL Searching?

Is there a way to find a certain thing in SQL, like in a certain table, for instance on notepad or microsoft word you press ctrl + f and can search. Is there a way I can do this in SQL?

what are you looking for?

Read about SELECT statement with WHERE clause.

Depends for what you're looking for.. lets say for exmaple you're looking for a char, you do the next thing :

Use ps_GameData
GO

SELECT * FROM Chars
Where CharName = 'Ariez'
Go

___________________

Hope that helped (:

Its better to use the like command with modifiers so it will find every char that is similar to the name.

Use ps_GameData
GO

SELECT * FROM Chars
Where CharName like '%Ariez%'
Go

I think he is talking about searching for table names, field names, stored procedures, and other items from a global perspective in the management studio.

Quote:

Originally Posted by Apocalypsist Is there a way to find a certain thing in SQL, like in a certain table, for instance on notepad or microsoft word you press ctrl + f and can search. Is there a way I can do this in SQL?

try here [Only registered and activated users can see links. Click Here To Register...]

and if your looking for a particular item or items in a table try creating a new View, it's pretty much does what lilprohacker is talking about.

Quote:

Originally Posted by ProfNerwosol Read about SELECT statement with WHERE clause.

This is a quick and easy website to test some of your SQL statement online: [Only registered and activated users can see links. Click Here To Register...]

This link is a less then 5 minutes reading on how to use the "SELECT" statement.
* = all (table, fields, etc...)
% = wild card

I'm trying to learn SQL, if there is a mistake, please point it out so I can correct it.