Bruno Barradas Posted February 11, 2021 at 12:33 AM Report Share #621300 Posted February 11, 2021 at 12:33 AM Tenho esta consulta que funciona perfeitamente no caso da variável texto possuir o conteúdo total do campo Autores. Contudo aquilo que necessito é que ele faça a pergunta "contem" e não se "existe" $query_catalogo = sprintf("SELECT * FROM catalogo where Autores LIKE '$texto' "); Alguem pode ajudar-me a entender o que fazer? Obg Link to comment Share on other sites More sharing options...
Solution tiago.f Posted February 11, 2021 at 07:47 AM Solution Report Share #621302 Posted February 11, 2021 at 07:47 AM Olá. antes de mais não precisas do sprintf se não estás a usar placeholders na string. depois para o query funcionar com pedes, deves usar ‘%’: $query_catalogo = "SELECT * FROM catalogo where Autores LIKE '%" . $texto . "%'"; Link to comment Share on other sites More sharing options...
Bruno Barradas Posted February 11, 2021 at 05:51 PM Author Report Share #621308 Posted February 11, 2021 at 05:51 PM Muito Obrigado. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now