Postgres SELECT * FROM表WHERE column-varchar ==“字符串示例”？ [英] Postgres SELECT* FROM table WHERE column-varchar=="string-example"?
本文介绍了Postgres SELECT * FROM表WHERE column-varchar ==“字符串示例”？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我有下表：
CREATE TABLE lawyer (
id SERIAL PRIMARY KEY,
name VARCHAR NOT NULL UNIQUE,
name_url VARCHAR check(translate(name_url, 'abcdefghijklmnopqrstuvwxyz-', '') = '') NOT NULL UNIQUE
);
我要选择*从律师那里name_url = john-doe
推荐答案
字符文字用单引号引起来：
Character literals are put into single quotes:
SELECT *
FROM lawyer
where name_url = 'john-doe';
有关详细信息，请参见手册：
https://www.postgresql.org/docs/current/static/sql -syntax-lexical.html＃SQL-SYNTAX-CONSTANTS
See the manual for details:
https://www.postgresql.org/docs/current/static/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS
这篇关于Postgres SELECT * FROM表WHERE column-varchar ==“字符串示例”？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
