Ask a Question
Advertise on boostr.in
use like with field values in mysql using -'mysql,sql,like-operator'
use like with field values in mysql ¬†using -'mysql,sql,like-operator'
I stumbled into a delicate SQL problem when I needed to use a value from a field inside a LIKE %..% statement.
SELECT t1.Notes, t2.Name
FROM Table1 t1, Table2 t2
WHERE t1.Notes LIKE '%t2.Name%'
This is only an example from the top of my head to show what I need to do (I know this will not work). I need to use the value of t2.Name inside the LIKE %..%
I guess this is trivial when you know it ;)
Sep 7, 2015
to add a comment.
Your name to display (optional):
Email me at this address if my answer is selected or commented on:
Email me if my answer is selected or commented on
Privacy: Your email address will only be used for sending these notifications.
To avoid this verification in future, please