SQL like query dosn't work

[ravi Sakhavala]

In text editor like query doesn't work.

[dsonesuk]

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.

[Ingolme]

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.

[Red_Carpet]

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

[Makwana Prahlad]

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😇