SQL Searching?

[AriezOMG]

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?

[lilprohacker]

what are you looking for?

[ProfNerwosol]

Read about SELECT statement with WHERE clause.

[GM.Triest]

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 (:

[lilprohacker]

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

[abrasive]

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.

[sunder702]

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

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.

[Gatewayto]

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:

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.