how to use LIKE with column name

Question

Normally LIKE statement is used to check the pattern like data   example    select   from table1 where name like  ar     My problem is to use one column of table with LIKE statement    example   select   from table1  table2 where table1 x is like table2 y    Query above results error   how to use one column data in like query

User · Answer

SQL SERVER   WHERE ColumnName LIKE     ColumnName

User · Answer

declare  LkeVal as Varchar 100  declare  LkeSelect Varchar 100   Set  LkeSelect    select top 1  lt column gt  from  lt table gt  where  lt column gt     value   Set  LkeVal          LkeSelect  select   from  lt table2 gt  where  lt column2 gt  like     LkeVal

User · Answer

For SQLLite you will need to concat the strings  select   from list1 l  list2 ll  WHERE l name like      ll alias

User · Answer

ORACLE DATABASE example   select    from table1 t1  table2 t2 WHERE t1 a like         t2 b

User · Answer

WHERE table1 x LIKE table2 y

User · Answer

You re close   The LIKE operator works with strings  CHAR  NVARCHAR  etc    so you need to concattenate the     symbol to the string       MS SQL Server   SELECT   FROM table1 table2 WHERE table1 x LIKE table2 y          Use of LIKE  however  is often slower than other operations   It s useful  powerful  flexible  but has performance considerations   I ll leave those for another topic though       EDIT   I don t use MySQL  but this may work     SELECT   FROM table1 table2 WHERE table1 x LIKE CONCAT table2 y

[sql] how to use LIKE with column name

Examples related to sql

Examples related to mysql