SQL lower() on one side of WHERE statement works for part of result but not all?

MySQL
I will happily take an edit on the title - I have no clue what to call this. Basically, I'm looking for an explanation to something I just came across...
2 years ago

what is wrong with this query? I am trying to update a column value based on the value of a column in a second table

MySQL
So I am trying to update the value of column Proveedor_Logo in table Natan_Procesos with the value of column Proveedor_Logo in table Natan_Proveedor w...
2 years ago

Insert ArrayList into MySQL

MySQL
I trying to insert ArrayList into MySQL, but I only gets the last values in column selected_seats. The variable list holds value 2 and 3. When I check...
2 years ago

Fetch mysql data from PHP using radiobutton control

MySQL
I would like to manipulate PHP code to search for specfic data in the sql database that matched. For example, let's say I want to search for an IP ma...
2 years ago

MySQL Query 2 Tables Join Column beside

MySQL
I have 2 tables, called tb_compulsory_savings and tb_time_deposits for tb_compulsory_savings form_no | badge_id | compulsory_savings | transaction_d...
2 years ago

Insert data into Wordpress database yable from a custom form

MySQL
I am trying to insert data into Wordpress database by creating a table. I have created the table but when I try to insert the data from form, it does ...
2 years ago

Mysql : I need to search record where searched text is matched with third word

MySQL
I need to search record where searched text is matched with third word from database record. Example : Suppose i have three records in description fi...
2 years ago

Mysql Mathematics on the fly

MySQL
I am doing a migration from one database structure to another where there are rating values in a column. In database table A the rating is 0-10 in d...
2 years ago

MySQL COUNT values fo each column

MySQL
I’m trying to figure out how to count the values in more than one column. It seem the first COUNT I do gives me the correct results but everything I’v...
2 years ago

Best practices for efficiently storing md5 hashes in mysql

MySQL
Possible field types: BINARY(16) CHAR(32) BIGINT + BIGINT How do I decide which one to use? ...
2 years ago

Error SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=#

MySQL
I am facing a problem with my query ... SELECT keywords.keyword, keywords.keyid, sources.s_title, sources.s_disc, sources.s_link, sources.sourceid,...
2 years ago

Select unique values from Database

MySQL
Im having some troubles showing the unique values from my database. As an example, I have this very simple test table: Where you can see that ther...
1 year ago

Generate Visio ERD from existing MySQL Database

MySQL
Is there a simple way to generate an ERD in Visio from an existing MySQL Database? I'm aware that this is possible in MySQL Workbench, but I have a re...
1 year ago

Laravel (5.3) Eloquent - Relationship issue

MySQL
I have the following 3 tables which are normalised: `Table: TheMovies` id | MovieName --------------------- 1 | Zootopia 2 | Moana...
1 year ago

Does Laravel close automatically the DB connections?

MySQL
I'm working with Laravel and Databases (DB) using Eloquent and MySQL. I already found the code to close the DB connection, but I was searching on th...
1 year ago

Seperate MYSQL results into seperate HTML Tables

MySQL
I have the following in which I am trying to make seperate HTML tables after each group: $query = "SELECT * FROM NonBillableTime WHERE TimeIn LIKE '$...
1 year ago

MySql Query for one to many relationship

MySQL
Facing issue in mysql query, tried with mysql join but not getting expected output. I want all class, all student record with total ratingscore.Each ...
1 year ago

How fix error with PHP login that ask tow times for username and password

MySQL
when i want to login with this codes in first time i connect to internet, i enter the username and password and push submit and the page get refresh a...
1 year ago

mySQL Select from two tables and match result

MySQL
I'd like to SELECT DISTINCT column1, column2 as t1 And i'd like to SELECT column3 FROM table2 WHERE column4 = "1" AND column3 = (matches)t1.colu...
1 year ago

Don't add exact same 3 columns value in Mysql

MySQL
I need to add a CSV file in a database. But after I add one file, some weeks later I need to add a new update of the file. Problem is: Duplicate rows ...
1 year ago