Jump to content

SQL like query dosn't work


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 post
Share on other sites
  • 2 weeks later...

Hi there - you will have to give us more information or we may have to treat this as a TROLL question.

Link to post
Share on other sites

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 post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...