I am studying SQL and I have been trying to see what is wrong with this and can't seem to figure it out.
SELECT *
FROM l_suppliers
WHERE suppliers_name = 'frank reed's vegetables';
-
Rachel: Welcome to Stack Overflow! It looks like you received some good answers pretty quickly to this, but for future questions you should also post the error messages that you are receiving. It wasn't necessary here for some people to see your problem, but it will be more helpful as you learn more and get into more complex areas.Mark Hildreth– Mark Hildreth2012-09-26 22:08:15 +00:00Commented Sep 26, 2012 at 22:08
Add a comment
|
7 Answers
You've got a quote mark ' in the middle of your quotation. Try this:
SELECT * FROM l_suppliers WHERE suppliers_name = 'frank reed''s vegetables';
Comments
you need to escape the string delimiter ' with '' or \'
SELECT * FROM l_suppliers
WHERE suppliers_name = 'frank reed''s vegetables';
Otherwise the SQL engine would think that the string ends after reed and does not know what to do with the rest of the query.
Comments
The problem is with ', you have to use escape char like \ or '.
For example oracle, tsql (sybase, ms sql server):
SELECT * FROM l_suppliers WHERE suppliers_name = 'frank reed''s vegetables';
Comments
It looks like you have an incomplete string in the statement.
You must escape the ' with '' in order to successfully execute it.
SELECT * FROM l_suppliers WHERE suppliers_name = 'frank reed''s vegetables';
Comments
You can try this it might give different results
SELECT
*
FROM l_suppliers
WHERE suppliers_name = 'frank reed''s vegetables';
or
SELECT
*
FROM l_suppliers
WHERE suppliers_name LIKE 'frank reed''s vegetables%';
or
SELECT
*
FROM l_suppliers
WHERE suppliers_name LIKE '%frank reed''s vegetables%';
Comments
In sql it is used the single quote for delimiting alfanumeric fields, so if you have a single quote inside your string sql thinks it ends there. You must escape it or replace it with ''.
