Discussion :: Introduction to SQL - General Questions (Q.No.11)
| 11. | The SQL keyword(s) ________ is used with wildcards. |
|||||||
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.