MySQL like another field

mysql sql-like
SiberianGuy picture SiberianGuy · Feb 3, 2011 · Viewed 27.2k times · Source

I have a table with two string columns: Url and ModelId. I need to return records for which Url contains ModelId, something like this:

SELECT Id, Url, ModelId WHERE Url like "%ModelId%"

Answer

Michael Robinson picture Michael Robinson · Feb 3, 2011 
SELECT Id, Url, ModelId 
WHERE Url LIKE CONCAT('%', ModelId, '%')

Related questions

How can I search (case-insensitive) in a column using LIKE wildcard?

I looked around some and didn't find what I was after so here goes. SELECT * FROM trees WHERE trees.`title` LIKE '%elm%' This works fine, but not if the tree is named Elm or ELM etc... How do …

Read More
MySQL Like multiple values

I have this MySQL query. I have database fields with this contents sports,shopping,pool,pc,games shopping,pool,pc,games sports,pub,swimming, pool, pc, games Why does this like query does not work? I need the fields with …

Read More
MySQL: NOT LIKE

I have these text in my db, categories_posts categories_news posts_add news_add And I don't want to select the rows with categories, I use a query something like this, SELECT * FROM developer_configurations_cms WHERE developer_configurations_…

Read More