CODEWITHSUNDEEP
sqlpostgresql
Hodiya Eyal
Hodiya Eyal

Reputation: 73

How to refer to one of the column inside a SQL query

I have some rows in an SQL table. I have attributes as: id, name, etc. Some of the names (in the name column) are built from some name ("xyz") and the id

id               name
333            regularName
555           somename.555  
666           myName.666

I want to select only rows that don't include the id inside the name.

So my query was:

select * 
from MY_TABLE 
where name not like '%.id'

But it refer to id as a string

Is there a way to refer to one of the columns value inside the query?

Upvotes: 0

Views: 55

Answers (2)

trillion
trillion

Reputation: 1401

select * from table
where 
not regexp_like(name, '.[0-9]+')
  • if regex is supported you can use this

Upvotes: -1

user330315
user330315

Reputation:

You need to concatenate the ID into the comparison string:

select * 
from MY_TABLE 
where name not like concat('%.', id::text);

Upvotes: 1

Related Questions