cathie — 2010-01-22T04:17:49-05:00 — #1
Anyone knows it possible to compare 2 fields using %like% in mysql?
eg t1.title = t2.author become t1.title like %t2.author% ?
I tried but is not working...
Wondering is there any other way to do this...
sjh — 2010-01-22T04:31:56-05:00 — #2
The syntax would be
WHERE t1.title LIKE '%' + t2.author + '%'
r937 — 2010-01-22T05:42:29-05:00 — #3
SJH, you've been working in the la-la-la dreamland of microsoft too long
the mysql syntax would be
WHERE t1.title LIKE CONCAT('%' , t2.author , '%')
sjh — 2010-01-22T05:49:38-05:00 — #4