Like pattern in sql query

Question

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?

chaitanya pathak · Answer

SELECT * FROM tableNeme where ColumnName like '_%n%_' if this answer is useful mark this as answer

Manoj Bhoir · Answer

Hi Try this query : Select * From TableName where Substring ( Name  2  LEN ( Name )- 2 ) Like '%n%'

Manas Mohapatra · Answer

Hi  Please use below query: select * from tablename where name like '%_n_[^n]%'