Database - Introduction to SQL - Discussion

Discussion :: Introduction to SQL - General Questions (Q.No.11)

11. 

The SQL keyword(s) ________ is used with wildcards.

[A]. LIKE only
[B]. IN only
[C]. NOT IN only
[D]. IN and NOT IN

Answer: Option A

Explanation:

No answer description available for this question.

Mani said: (Mar 23, 2011)  
Wildcard means?

Neha Goyal said: (Aug 8, 2011)  
What is wildcard ?

Baburao said: (Aug 11, 2011)  
Wildcard means %text enclosed with single quote.
ex: cname like '%BU'

Prabhakar said: (Sep 12, 2011)  
Thanks it is useful.

Bipin said: (Jan 17, 2012)  
Wildcard means %text enclosed with single quote.

Shikha said: (Mar 14, 2012)  
Yes @baburao and @bipin explained this very closely. Thats right and I agree with them.

Vikas said: (Jul 15, 2012)  
Like keyword used two wildcard 1. '_' for single character, 2. '%'for multiple character.

Ali said: (Mar 1, 2014)  
Using the _ Wildcard.

Now we want to select the persons with a first name that starts with any character, followed by "la" from the "Persons" table. We use the following SELECT statement:

SELECT * FROM Persons WHERE FirstName LIKE '_la'

Divya said: (Apr 9, 2014)  
If you want to select persons name from persons table ending with d and starting with m,
Then use the syntax like this,

select * from PERSONS where personname like 'm%d';

Ex: mad, mohammad, married, mustard, etc.,

And to retrieve persons name where 5th letter is d and 7th letter is s and after s you can have any characters, then use,

select * from PERSONS where personname like '_ _ _ _ d_s%'

Ex: kalidas.

Lalitha said: (Jan 8, 2015)  
This notes really help to know about wild cards in SQL.

Gayatri said: (Jun 12, 2016)  
A wildcard character can be used to substitute for any other character(s) in a string. SQL wildcards are used to search for data within a table.

For Example1:
SELECT * FROM Customers
WHERE City LIKE 'ber%';
//Displays table containing city starting with Ber...//

For Example2:
SELECT * FROM Customers
WHERE City LIKE '%es%';
//Displays table containing city ending with es...//

Ramesh said: (Jul 18, 2016)  
Wildcard is special character is represent to another character.

Like as run* -->then result get out run, runing, runs.

Sufi said: (Aug 26, 2016)  
Thanks, Now my doubt on wildcard is much cleared.

Argha Sarkar said: (Sep 8, 2017)  
Thank you.

Post your comments here:

Name *:

Email   : (optional)

» Your comments will be displayed only after manual approval.