Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

MySQL like another field

Tags:

mysql

sql-like

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%"
like image 420
SiberianGuy Avatar asked Feb 03 '11 12:02

SiberianGuy

People also ask

How do I use like between two columns in SQL?

The SQL LIKE OperatorThe LIKE operator is used in a WHERE clause to search for a specified pattern in a column. There are two wildcards often used in conjunction with the LIKE operator: The percent sign (%) represents zero, one, or multiple characters. The underscore sign (_) represents one, single character.

Does MySQL have Ilike?

In MySQL you do not have ILIKE. Checkout MySQL docs on string comparison functions.

How can I check if one column value is present in another column in SQL?

The SQL EXISTS Operator The EXISTS operator is used to test for the existence of any record in a subquery. The EXISTS operator returns TRUE if the subquery returns one or more records.

2 Answers

SELECT Id, Url, ModelId  WHERE Url LIKE CONCAT('%', ModelId, '%')
like image 169
Michael Robinson Avatar answered Sep 21 '22 06:09

Michael Robinson

You can not just concat the strings, you must also escape the field from % and _:

SELECT Id, Url, ModelId  WHERE Url LIKE CONCAT('%', REPLACE(REPLACE(ModelId,'%','\%'),'_','\_'), '%'), '%')
like image 31
tal952 Avatar answered Sep 21 '22 06:09

tal952
Sign in to Comment

Related questions

SQL Join on a column LIKE another column [duplicate]
Entity Framework with MySql and Migrations failing because "max key length is 767 bytes"
How to insert a file in MySQL database?
Order by last 3 chars
Hibernate auto create database
virtualenv(python3.4), pip install mysqlclient error
Truncate all tables in MySQL database that match a name pattern
MYSQL Case in select statement for checking null
How do I search a MySQL database for a specific column name? [duplicate]
mysqli or die, does it have to die?
MySQL changing authentication type from standard to caching_sha2_password
SHOW TABLES statement with multiple LIKE values
query "not equal" doesn't work
Mysql where id is in array [duplicate]
Codeigniter LIKE with wildcard(%)
Laravel whereIn OR whereIn
ALTER TABLE add constraint
MySQL performance: multiple tables vs. index on single table and partitions
Python and Django OperationalError (2006, 'MySQL server has gone away')
Backup MySQL users

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!