MySql: CONCAT

Problem:

Trebamo spojiti dva polja prilikom pretrage. Npr. ime i prezime

Rješenje:

SELECT * from tablica WHERE CONCAT(ime," ",prezime) = 'Pero Perić'

CONCAT možemo upotrijebiti i kod select-a:

SELECT CONCAT(ime," ",prezime) as korisnik  from tablica WHERE CONCAT(ime," ",prezime) = 'Pero Perić'
This entry was posted on Friday, April 29th, 2011 at 1:14 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.