help finding part of one field in another 1

[anabavi]

I want to find/delete the contents of a field, Address6, if it contains (not necessarily exclusively) the contents of the City field. I can't figure out how to do this. I've tried things like:

select address6, city from table where city in(address6)
. . . but that only shows exact content matches

select address6, city from table where address = '%'city'%'

select address6, city from table where address = concat('%',city,'%')

. . . and variations on those. I'm trying to do it without using PHP, just MySQL. Is there a way to do this entirely within MySQL?

Thanks a lot,


Ali

 

[sleipnir214]

How 'bout:

select address6, city from table where address like concat('%',city,'%')

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[anabavi]

Yippee! Cookin' with gas, now!

Thank you so much, that worked perfectly.

By the way, I'm reading "How To Ask Questions The Smart Way" right now. Hopefully I didn't start reading it too late. I'm thinking about putting a link to it on our corporate site because it is so enlightening.

Thanks again,


Ali