تبلیغات
SQL - عملگر LIKE :

عملگر LIKE :

نویسنده :tamishan tamishan1
تاریخ:سه شنبه 23 آبان 1391-12:50 ق.ظ

مثال : Query بنویسید که انهایی را نشان بده که حرف اول  انها  M باشد.

 

 

SELECT

                          *

FROM

               Student

WHERE

       FirstName     like  'S %'

City ID

LastName

FirstName

Age

ID

30

Panahi

Sara

36

3

 

مثال : Query بنویسید که انهایی را نشان بده که حرف اخر  انها  a باشد.

SELECT

                          *

FROM

               Student

WHERE

       FirstName     like  ' % a'

City ID

Last Name

First Name

Age

ID

10

Bandpey

Mahla

21

1

20

Baghery

Samira

54

2

30

Panahi

Sara

36

3

40

Salimi

Mona

15

4

 

 مثال : Query بنویسید که انهایی را نشان بده که داخل حرف  انها  S باشد.

SELECT

                          *

FROM

               Student

WHERE

       FirstName     like  ' % S %'

City ID

Last Name

First Name

Age

ID

20

Baghery

Samira

54

2

30

Panahi

Sara

36

3

 




داغ کن - کلوب دات کام
نظرات() 
http://hurrieddrudge1227.jimdo.com/2015/06/25/contracted-big-toe
سه شنبه 24 مرداد 1396 12:47 ب.ظ
Hey there! I just wanted to ask if you ever have any trouble with hackers?

My last blog (wordpress) was hacked and I ended up losing many months
of hard work due to no backup. Do you have any solutions to protect against
hackers?
Do compression socks help with Achilles tendonitis?
یکشنبه 15 مرداد 1396 11:58 ب.ظ
I'm truly enjoying the design and layout of your blog. It's a very easy on the eyes which makes it much more enjoyable for me to come here and visit more often. Did you hire out a designer to
create your theme? Excellent work!
Can exercise increase your height?
یکشنبه 15 مرداد 1396 07:15 ب.ظ
Excellent goods from you, man. I've have in mind your
stuff previous to and you're just extremely fantastic.

I really like what you've bought here, really like what you're saying and
the way wherein you are saying it. You're making it enjoyable and you continue to care for to stay it wise.
I cant wait to learn far more from you. This is
actually a terrific web site.
simonnedunnigan.jimdo.com
سه شنبه 2 خرداد 1396 01:28 ق.ظ
It's going to be end of mine day, but before finish I am reading this great piece of writing to increase my knowledge.
BHW
شنبه 2 اردیبهشت 1396 08:33 ب.ظ
Hi, i think that i saw you visited my weblog thus i came
to “return the favor”.I am trying to find things to
enhance my website!I suppose its ok to use some of your ideas!!
BHW
سه شنبه 29 فروردین 1396 06:21 ب.ظ
Howdy! Do you know if they make any plugins to protect against hackers?
I'm kinda paranoid about losing everything I've worked hard on. Any
tips?
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر




Admin Logo
themebox Logo