How do I ask / combine 2 SQL SELECTS and put the result in a php variable? [cIosed]

Question

I want to combine

SELECT * FROM form

with

SELECT REPLACE(/var/WWW/html, "/var", "/vur")

After that I want to put it in a php variable.

I tried this:

$SQL = "SELECT * FROM form" with "SELECT REPLACE (/var/WWW/html, "/var", "/vur")"

I want SELECT everything of my database but I also want to replace text from one column.

It should be like this:

Is this possible? And how?

Do you want ALL the columns ( i.e. * ) or just the replaced value of column ??12?? — RiggsFolly, Jun 05 '19 at 10:56
I want to get everything (*) and I want to replace "/var" with "/vur" from column "businessCard". :) — qpA, Jun 05 '19 at 10:59

score 3 · Accepted Answer · answered Jun 05 '19 at 10:54

3

If I have understand your issue, this query should solve it

SELECT *, REPLACE(myColumn, "/var", "/vur") something FROM form

answered Jun 05 '19 at 10:54

Sergio Rinaudo

I will check it in a minute but I think its the right way :) – qpA Jun 05 '19 at 11:01
1

Don't worry :) I also advise you not to use the SELECT *, check this out https://stackoverflow.com/questions/321299/what-is-the-reason-not-to-use-select – Sergio Rinaudo Jun 05 '19 at 11:04

score -2 · Answer 2 · answered Jun 05 '19 at 10:52

-2

Maybe you searched for the SQL UNION command.

answered Jun 05 '19 at 10:52

root_id

2 Answers2