Entry

Database: Language: SQL: Table: Operation: Search: How to search data in a table? [select / get]

Mar 20th, 2005 02:43
Knud van Eeden,

----------------------------------------------------------------------
--- Knud van Eeden --- 20 March 2005 - 04:45 pm ----------------------

Database: Language: SQL: Table: Operation: Search: How to search data 
in a table? [select / get]

---

Use the SQL command:

 SELECT <list of your columnames> FROM <your table name> WHERE <your 
expression>

---
---

General format:

-----------------------------------------------
SELECT
 <columnname1>,
 <columnname2>,
 ...,
 <columnnameN>
FROM
 <mytable1>
WHERE
 <columnname1> = '<value1>'
AND / OR
 <columnname2> = '<value2>'
AND / OR
 <columnname3> = '<value3>'
...
AND / OR
 <columnnameN> = '<valueN>'
;
-----------------------------------------------

---
---

e.g.

-----------------------------------------------
SELECT
 *
FROM
 Person
-----------------------------------------------

---
---

e.g.

-----------------------------------------------
SELECT
 Name, PersonKey
FROM
 Person
-----------------------------------------------

---
---

SELECT
 columnNameS,
 columnStreetS,
 columnCityS,
 columnZipCodeS,
 columnCountryS
FROM
 tableAddressS
WHERE
 columnFirstNameS = 'Knud'
AND
 columnLastNameS = 'van Eeden'
;

---
---

Internet: see also:

---

Database: Language: SQL: Overview: Can you give an overview of links 
about SQL?
http://www.faqts.com/knowledge_base/view.phtml/aid/32811/fid/54

----------------------------------------------------------------------