Jump to content
ravi Sakhavala

SQL like query dosn't work

Recommended Posts

Well in my text editor like query does work, you must have a faulty broken text editor, as its obvious it could never be anything you done.

Share this post


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

Share this post


Link to post
Share on other sites

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

Share this post


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😇

Share this post


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...