Need help about SQL LIKE statement
Asked By
0 points
N/A
Posted on - 05/09/2012
I need to know how the LIKE statement is working in a query.
Please give me some examples.
Best Answer
Best Answer
Need help about SQL LIKE statement
Well,
“LIKE” is clause that use in any SQL query to retrieve data which have particular part or phase of a particular column we specified with that.
When we need to write a query that need to retrieve names from a column that store set of names which starts with certain characters or which having certain characters in the middle of the name.
See below example.
Assume we need to retrieve all data which the user name starts with ‘sa’ (assume the column’s name is username)
SELECT * FROM <table name>
WHERE username LIKE ‘sa%’
*The “%” marks meaning is any amount of characters after ‘sa’
If you need to retrieve user names which having ‘sa’ in the middle of the usernames,
SELECT * FROM <table name>
WHERE username LIKE ‘%sa%’
Need help about SQL LIKE statement
The SQL LIKE operator is applied when using a WHERE clause. Its function is to look for a particular pattern in a column. Below is the proper syntax for the SQL LIKE operator:
Here is an example of how the LIKE operator is used. In the table below you will see names of persons living in the city. Now, what we want to do is to select the persons that end with an “s”.
To do this, we apply the following statement:
The “%” symbol beside the letter “s” is used to indicate or define wildcards. It can be placed either before or after the specified pattern or more precisely before or after the letter “s”. The result would be:
Need help about SQL LIKE statement
Hello adviser, take my compliments for your precious comments. Although, the SQL LIKE operator is difficult for me with a limited knowledge but I am interested to write better filter expressions with the SQL LIKE operator, so I need your help. Everyone comments were comprehensible but Norwood-Koonce your comments made me puzzled to realize my task for your complex description. Sharath your explanation with example was very reliable and easy-to-use to me, for that your comments touched my mind. For your example, now I am able to configure my task and I can easily manage the SQL LIKE operator that base on your example in the comment. Thanks Sharath, I will get into a scrap if you will not help me.
Related Questions
Latest Articles
Best Mirrorless Cameras
Mirrorless camera is the latest obsession among the photographers. The cameras have altogether replaced the traditional DSLR models with their unique and special features.
A mirrorless camera is a light-weighted electronic device device that utilizes...
Improve Your Manuscript Before Publishing: Eight Ways To Help
Every author expects to experience a sense of achievement unlike any other when they complete their manuscript. However, some authors agree that they do not feel fully satisfied looking back at the achievement that...
Top 10 Artificial Intelligence Cryptocurrency
It is a type of digital currency. It can be consumed or negotiated, but it is not issued by central banks or retained in financial institutions. It enables transactions without involving central banks or...
Latest Blogs
Top 10 New Laptop Entrants That Shook The Public
The finest laptops are powerful enough to do your daily tasks, comfortable enough to use all day, and power-efficient enough to ensure you don't run out of battery power unexpectedly. Of course, all these...
10 Facts About The Dark Web
Before getting into knowing the facts, let’s have a brief about the Dark Web. The dark web is the data of the World Wide Web that is accessible only through special software, combinations, or...
Top 10 Latest Steam Cleaner Machines
While looking for a chemical-free way to clear and purify both durable and low grounds in your home, a steam cleaner is an excellent solution. With a spurt of superheated steam, this cleaning equipment...
Latest Tips
Top 10 Internet Monitoring Software
Internet monitoring software keeps a log of all internet activities. You can install this type of software on your computer remotely or by the administrator. An operating console controls this software. This type of...
Top 10 Best Partition Manager Software
A Hard Disk Drive is usually partitioned into various smaller drives for optimization. A partition manager helps make this process easier and more efficient. Here, let’s discuss the top 10 best partition manager software.
1....
Top 10 Best Online Music Production Software
Music production is the initial stage of any song. Music production can be done either in studios or at home using an online music production software. Here, let’s discuss the top 10 best online...
