Use '%' with column names in MYSQL select statement?

Question

I have a query that looks at partial matches within two mysql tables to make a join:

SELECT table1.column, table2.column FROM table1, table2 WHERE table1.val LIKE table2.val

This works fine as a join, but... some of the values in table2 are actually substrings of the values in table one—specifically they're urls. So, table1.val might equal http://google.com while table2.val = google.com.

How do I use the '%' operator around the table2 val to make this comparison.

Thanks in advance!

user149341 · Accepted Answer · 2012-05-01 22:45:51Z

4

Like this:

... WHERE table1.val LIKE CONCAT('%', table2.val, '%')

Note that this will not perform as well as table1.val = table2.val, as it must now search all rows in table2.

answered May 1, 2012 at 22:45

user149341

Sign up to request clarification or add additional context in comments.

Comments

paulsm4 · Accepted Answer · 2012-05-01 22:45:06Z

0

Q: How do I use the '%' operator around the table2 val to make this comparison.

A: You don't :)

You can specify a column by name (e.g. "mycolumn"), by fully qualified name (e.g. "mytable.myname") or by ordinal (e.g. "1").

answered May 1, 2012 at 22:45

paulsm4

123k23 gold badges175 silver badges245 bronze badges

Collectives™ on Stack Overflow

Use '%' with column names in MYSQL select statement?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related