Jump to content

SQL like query dosn't work


ravi Sakhavala
 Share

Recommended Posts

On 6/17/2020 at 11:25 AM, ravi Sakhavala said:

In text editor like query doesn't work.

Could you explain in more details what the issue is? What result are you seeing and what was the expected result?

Text editors don't usually run SQL unless you have some kind of database plugin for your text editor.

Link to comment
Share on other sites

  • 2 weeks later...

The following SQL statement selects all customers with a CustomerName starting with "a":

SELECT * FROM Customers
WHERE CustomerName LIKE 'a%';

The following SQL statement selects all customers with a CustomerName ending with "a":

SELECT * FROM Customers
WHERE CustomerName LIKE '%a';

The following SQL statement selects all customers with a CustomerName that have "or" in any position:

SELECT * FROM Customers
WHERE CustomerName LIKE '%or%';

For more information follow this link

https://www.w3schools.com/sql/sql_like.asp

 

Thnak you😇

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...