Need help with SQL [closed]

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 11 years ago.

i want to choose all the LIKE values 开发者_运维技巧but not a specific one

---

select * from names where name like 'ro%' and name != 'root';

Will give you all ro* except root.

If you want to use multiples

select * from names where name like 'ro%' and name not in ('root', 'rooster');

---

This is an example for a LIKE query:

SELECT * FROM yourtable WHERE NAME LIKE "John%"

This will return all rows which have the value "John *" in the name column.