I have already posted my question at:
I thought I found the solution there but there is a problem:
solution (that does not woirk correctly)
SELECT CONCAT('pix1/', LEFT(username,1),'/',LEFT(
), '/', username , '-1.jpg')
It makes a kind of recurrent selection that make the result growing all the rime !
here is my request again
I have in my database users, fields name username who contains for instance the value dialogoo
I need to write a simple select function that selects:
pix1 is FIXED
d is the first letter
di are the first 2 letters
-1.jpg is fixed
so it it something like
Any clue ?