Most voted "select" questions
USE THIS TAG ONLY WHEN REFERRING TO DATABASE. SELECT is an SQL statement that returns zero or more rows, from one or more base tables, temporary tables, or views in a database. DO NOT USE to refer to the HTML "select" element, in which case use [html-select].
Learn more…807 questions
Sort by count of
-
-3
votes1
answer792
viewsVery slow MYSQL query, more than 25 seconds, how to improve?
I have a query in mysql that is very slow , more than 25 seconds. The base is quite large, around 1,000 records of real estate (table osrs_properties) and 16,000 photo records (table osrs_photos).…
-
-4
votes1
answer15542
viewsError "Warning: mysqli_query() expects Parameter 1 to be mysqli, null Given"
I am developing a PHP API, which is hosted on Hostinger. However, when I do the SQL query on Mysqli, I get the same error no matter what changes I make to the code: Warning: mysqli_query() expects…
-
-4
votes1
answer258
viewsWHERE clause with PHP coming from Javascript
I need to pass a variable from PHP in a clause WHERE of a SELECT, but this PHP variable gets a value from JAVASCRIPT. I ran a test passing only a native PHP value and it worked: <?php $phpNum =…
-
-4
votes0
answers29
viewsIn Bigquerym, how to find a text in a column based on another table and column
I made the example below with a blocklist table (where I have all the words that cannot appear in a product description). The product table, where I want to find these blocklist words in the product…
-
-5
votes1
answer949
viewsCalculate date time in mysql
I have a log tab with a TIMESTAMP type column that saves the user’s login and logout time. I need a select compare the time of login and logout of the user to calculate the time that the same stayed…
-
-7
votes1
answer105
viewsRefer to PHP PDO user
For those with the doubt as I had, below I’ll leave the code ready, just change to your project. The code is simply to know the user logged in and say his name in PHP PDO. If your project is by…
-
-7
votes2
answers117
viewsHelp with SELECT for the Acuity exam
I need help with a college test. I’m new in SQL, and I need to do well on this test. I wonder if someone could help me form this SELECT correctly? I don’t even know where to begin, so I really…