Loading

Like pattern in sql query

mangai vellingiri

11y1.1kSQL

Sir,

I have doubt in sql query like pattern. Consider the scenario,

roll no	name
1	karnan
2	karan

Now i want to retrieve the name with middle character 'n'. If i use query select * from tablename where name like '%n%', it retrieves the name karnan and karan. But my scenario is to retrieve only the character with 'n' in middle. In karan, 'n' is at end. The end character may anything but my scenario is i want name with 'n' in middle. What query i can use here?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

chaitanya pathak10y ago
SELECT * FROM tableNeme
where ColumnName like '_%n%_'

if this answer is useful mark this as answer
Manoj Bhoir11y ago
Hi,

Try this query :

Select * From TableName where Substring(Name,2,LEN(Name)-2) Like '%n%'
Manas Mohapatra11y ago
Hi ,

Please use below query:

select * from tablename where name like '%_n_[^n]%'