MySql: polje LIKE drugo polje

Problem:

Napraviti query gdje je vrijednost polja LIKE vrijednost drugog polja

Rješenje:

SELECT fieldName1, fieldName2 FROM tableName WHERE fieldName1 LIKE CONCAT('%', fieldName2, '%')
fieldName1
This entry was posted on Tuesday, April 5th, 2011 at 11:59 pmand is filed under MYSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.