0
I have a table that stores screen urls from my system, I wanted to perform a query that returns me a url that comes parameterized as follows /avaliacoes-cozinha-segura/avalia-cozinha/2
to that url that is stored so /avaliacoes-cozinha-segura/avalia-cozinha/
, I tried to use the like but it didn’t work out too well:
SELECT * FROM fogasdigital.TelaPerfil where url like ('%/avaliacoes-cozinha-segura/avalia-cozinha/2%');
because apparently the like would only work if the url was smaller than the one that is stored, but unfortunately I have no way to bring it reduced from the backend, I also tried to use the in but also did not succeed. What’s impatient is this 2 that comes from the system.
The URL is recorded as /evaluations-kitchen-safe/evaluates-kitchen/ and you need to return it as /evaluations-kitchen-safe/evaluates-kitchen/2? The two in this story, is not present in the database, you just need for the return?
– Daniel Mendes
The url
/avaliacoes-cozinha-segura/avalia-cozinha/
is the one in the bank and the url/avaliacoes-cozinha-segura/avalia-cozinha/2
is the search parameterSELECT * FROM fogasdigital.TelaPerfil where url like ('%/avaliacoes-cozinha-segura/avalia-cozinha/2%');
– Brendon Iwata