I'm trying to select data from 2 separate tables, when one column is LIKE a column in the other table.

For example, I have tableA and tableB. col2 in tableA has a row with '"Jason"', and col2 in tableB has 'Jason' (without the double quotes), but I still want them to match.

This is what I thought would work, but doesn't (I just get a syntax error):

SELECT tableA.col1, tableB.col1
FROM tableA, tableB
WHERE tableA.col2 LIKE "%". tableB.col2 ."%"


Is there a correct way to use a wildcard here?

El 09/12/2011 10:56, Jason C escribió/wrote:
The LIKE operator expects a string:

http://dev.mysql.com/doc/refman/5.5/...#operator_like

So you need to compose a string and «.» is *not* a string operator in
SQL dialect I'm aware of. Try this instead:

http://dev.mysql.com/doc/refman/5.5/...unction_concat

Beware of NULL values and you're done.


--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--

On 2011-12-09 10:56, Jason C wrote:

select ta.col1 as ta_col1, tb.col1 as tb_col1
from ta
join tb
on tb.col1 like '%' || ta.col1 || '%';


/Lennart