E-mail Print PDF

WHERE

WHERE 

SELECT column_name(s)
FROM table_name
WHERE column_name operator value

There is a table "Persons":

P_IdLastNameFirstNameAddressCity
1 Hansen Ola Timoteivn 10 Sandnes
2 Svendson Tove Borgvn 23 Sandnes
3 Pettersen Kari Storgt 20 Stavanger

For this we use this query:

1
2

SELECT * FROM Persons
WHERE City=

Query Result:

P_IdLastNameFirstNameAddressCity
1 Hansen Ola Timoteivn 10 Sandnes
2 Svendson Tove Borgvn 23 Sandnes 

1
2

SELECT * FROM Persons WHERE FirstName= // 
SELECT * FROM Persons WHERE FirstName=Tove // 

1
2

SELECT * FROM Persons WHERE Year=1965 // 
SELECT * FROM Persons WHERE Year='1965' //

Description
=
>
<
<=
BETWEEN
IN

Note Note: !=

Comments

 
-1 #1 javadov 2010-12-06 18:34 Can you use 2 times the operator where
SELECT DISTINCT id,name,sername FROM Table1 where deleted=0 order by id
how do I add where name like='Tom' in this query?? Quote
 
 
-5 #2 javadov 2010-12-06 18:35
Can you use 2 times the operator where
SELECT DISTINCT id,name,sername FROM Table1 where deleted=0 order by id
* How do I add where name like='Tom' in this query??

how do I add where name '+ quotedstr (edit 1 Quote
 
 
+1 #3 yangus 2011-02-08 12:29
Can you use 2 times the operator where
SELECT DISTINCT id,name,sername FROM Table1 where deleted=0 order by id
* How do I add where name like='Tom' in this query??

how do I add where name '+ quotedstr (edit 1

SELECT DISTINCT id,name,sername FROM Table1
where deleted = 0 and name like 'Tom' / / but why here like to use?
order by id Quote
 

Authorization

Nice Ajax Poll

Which one of my extensions is the best?

Statistics

Translate

русскийitalianoDeutschEnglishLATVIANукраїнськаfrançaispolski
1

Advertisement


Квалифицированная помощь адвоката: юрист по жилищным вопросам.

© 2009 ageent.ru.