I would like to see images in a data table column that contains URL links to wp content images.   The query generated table succeeds in returning URLs,  but I don't see how to make the column into an "image" column that will display the images ?

I am a little confused perhaps about the syntax.   There is only one "   double quote in your code example ??.

Here is my sub-query:  (this line works to produce URLs)

(select meta_value from `wp_g1bf3tkaah_usermeta` where user_id = u.id and meta_key = 'user_meta_image' limit 1) as pix_URL

Do you supposed that adding the concat function within the subquery will work ?    I am only able to get syntax error results so far.  Perhaps I am using the wrong quote types,  or  ??

here is code that does not work:

 (select CONCAT ("<img src=", meta_value from `wp_g1bf3tkaah_usermeta` where user_id = u.id and meta_key = user_meta_image' limit 1),">" ) as pix

here is the little site sql query response to the above code;

My site is on flywheel,  and says that it is using InnoDB . 

But to answer your first question,  that is correct,  and the table output correctly has a column name pix_URL with URLs to wp content .jpg images.  Without the concat function,  I do get URLs and a table.

THe code line added to the below listed (in error message post)  overall query is also listed below.

Here is the query that works:  

 SELECT
u.id ,
u.user_login,
u.user_email,

(select meta_value from `wp_g1bf3tkaah_usermeta` where user_id = u.id and meta_key = 'first_name' limit 1) as first_name,
    (select meta_value from  `wp_g1bf3tkaah_usermeta`where user_id = u.id and meta_key = 'last_name' limit 1) as last_name,
    (select meta_value from `wp_g1bf3tkaah_usermeta` where user_id = u.id and meta_key = 'user_meta_image' limit 1) as pix_URL
 FROM wp_g1bf3tkaah_users AS u

Here is the modification that doesn't work: (to the third subquery)

 (select CONCAT ("<img src=", meta_value from `wp_g1bf3tkaah_usermeta` where user_id = u.id and meta_key = user_meta_image' limit 1),">" ) as pix

(This is not with added syntax change from your lates post.   I'm just providing the inputs you requested)

Here is a screenshot of the table generated from the working query:

The desired outcome is for the pix_url column show the target URL graphic,  and not a link.

I'll try your syntax now and see what happens

here is the replacement CONCAT subquery line:

 (select CONCAT ('<img src="', meta_value from `wp_g1bf3tkaah_usermeta` where user_id = u.id and meta_key = 'user_meta_image' limit 1)'">') as pix_URL

and here is what the flywheel sql sandbox error message returns as the line with syntax error:

(select CONCAT ('') as pix

Perhaps others could benefit from a table editing tool that allows a table structure column  to be converted to "image"   ?  Instead of jamming that process into the query ?   

Thanks very much,   I appreciate it.   Let me go give it a try!

Unfortunately,  when I edit the table and then click on the "settings"  button, and the data tab, for the pix_URL column that contains the picture urls  I want to show,   I get a different result:

I don't have a choice of column data type .....

That is what I did...    I am not offered the choice of changing string to image.

here is what I see:

I'll try the most recent concat syntax.   

I will open a new private ticket with the info.   I don't see anywhere to make this "private"