Postgres SELECT* FROM table WHERE column-varchar=="string-example"?
<p>I have the following table:</p>

<pre><code>CREATE TABLE lawyer (
  id SERIAL PRIMARY KEY,
  name VARCHAR NOT NULL UNIQUE,
  name_url VARCHAR check(translate(name_url, 'abcdefghijklmnopqrstuvwxyz-', '') = '') NOT NULL UNIQUE
);
</code></pre>

<p>I want to <code>SELECT * FROM lawyer where name_url = "john-doe"</code></p>