how to use LIKE with column name

by

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, '%')

More Related Contents:

  1. MySQL: Alternatives to ORDER BY RAND()
  2. Simple way to calculate median with MySQL
  3. MySQL LIKE IN()?
  4. Auto Increment after delete in MySQL
  5. Unioning two tables with different number of columns
  6. In MySQL queries, why use join instead of where?
  7. MySQL “NOT IN” query
  8. Emulate MySQL LIMIT clause in Microsoft SQL Server 2000
  9. Importance of varchar length in MySQL table
  10. Stored Procedure with optional “WHERE” parameters
  11. mySQL :: insert into table, data from another table?
  12. Return 0 if field is null in MySQL
  13. MySQL “between” clause not inclusive?
  14. SQLite – ORDER BY RAND()
  15. How to search multiple columns in MySQL?
  16. MySQL – Selecting data from multiple tables all with same structure but different data
  17. Can a stored procedure/function return a table?
  18. Adding a new SQL column with a default value
  19. Selecting all corresponding fields using MAX and GROUP BY
  20. MySQL full text search for words with three or less letters
  21. MySQL’s alternative to T-SQL’s WITH TIES
  22. Multiple Ranks in one table
  23. The difference between ‘AND’ and ‘&&’ in SQL
  24. How to transform vertical data into horizontal data with SQL?
  25. How do I list all the columns in a table?
  26. Two single-column indexes vs one two-column index in MySQL?
  27. What does collation mean?
  28. VARCHAR as foreign key/primary key in database good or bad?
  29. How do I create a table alias in MySQL
  30. MySQL: Get character-set of database or table or column?

Leave a Comment