Grover's algorithm - DES circuit as oracle?

Is it ethical to upload a automatically generated paper to a non peer-reviewed site as part of a larger research?

How can I protect witches in combat who wear limited clothing?

What aspect of planet Earth must be changed to prevent the industrial revolution?

In horse breeding, what is the female equivalent of putting a horse out "to stud"?

Does Parliament hold absolute power in the UK?

how can a perfect fourth interval be considered either consonant or dissonant?

Can the DM override racial traits?

Why is superheterodyning better than direct conversion?

Can a 1st-level character have an ability score above 18?

Segmentation fault output is suppressed when piping stdin into a function. Why?

Windows 10: How to Lock (not sleep) laptop on lid close?

Was credit for the black hole image misattributed?

Finding degree of a finite field extension

Can a novice safely splice in wire to lengthen 5V charging cable?

Why can't devices on different VLANs, but on the same subnet, communicate?

Didn't get enough time to take a Coding Test - what to do now?

The following signatures were invalid: EXPKEYSIG 1397BC53640DB551

Can the prologue be the backstory of your main character?

How is simplicity better than precision and clarity in prose?

Create an outline of font

Why did all the guest students take carriages to the Yule Ball?

How to delete random line from file using Unix command?

What can I do if neighbor is blocking my solar panels intentionally?

problem with substring in mysql

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

0

I have simple EAV like database which has 3 tables: products, attributes, attribute_values.

I am using below code to find all products that have attribute 'length' and then I am using substring function to get rid of 'inch' and after that I am using between to get all products that have 'length' between 0 and 5.

SELECT products.name,products.id

FROM products

JOIN attribute_value_product on products.id = attribute_value_product.product_id

JOIN attribute_values on attribute_value_product.attribute_value_id = attribute_values.id

JOIN attributes on attribute_values.attribute_id = attributes.id AND attributes.name = 'length'

WHERE substring_index(attribute_values.value,'inch',1) + 0 BETWEEN 0 AND 5

Everything works fine however I am getting plenty of warnings:

Warning: #1292 Truncated incorrect DOUBLE value: 'black'

Warning: #1292 Truncated incorrect DOUBLE value: 'phat farm'

Warning: #1292 Truncated incorrect DOUBLE value: '2 kg'

Warning: #1292 Truncated incorrect DOUBLE value: 'roca wear'

it looks to me like that substring is going through all attribute_values in the database, even those that are not reffering to attribute 'length' - is it possible to change that ?

mysql substring

share|improve this question

asked 10 mins ago

neocrkneocrk

1

add a comment | 

0

I have simple EAV like database which has 3 tables: products, attributes, attribute_values.

I am using below code to find all products that have attribute 'length' and then I am using substring function to get rid of 'inch' and after that I am using between to get all products that have 'length' between 0 and 5.

SELECT products.name,products.id

FROM products

JOIN attribute_value_product on products.id = attribute_value_product.product_id

JOIN attribute_values on attribute_value_product.attribute_value_id = attribute_values.id

JOIN attributes on attribute_values.attribute_id = attributes.id AND attributes.name = 'length'

WHERE substring_index(attribute_values.value,'inch',1) + 0 BETWEEN 0 AND 5

Everything works fine however I am getting plenty of warnings:

Warning: #1292 Truncated incorrect DOUBLE value: 'black'

Warning: #1292 Truncated incorrect DOUBLE value: 'phat farm'

Warning: #1292 Truncated incorrect DOUBLE value: '2 kg'

Warning: #1292 Truncated incorrect DOUBLE value: 'roca wear'

it looks to me like that substring is going through all attribute_values in the database, even those that are not reffering to attribute 'length' - is it possible to change that ?

mysql substring

share|improve this question

asked 10 mins ago

neocrkneocrk

1

add a comment | 

I have simple EAV like database which has 3 tables: products, attributes, attribute_values.

I am using below code to find all products that have attribute 'length' and then I am using substring function to get rid of 'inch' and after that I am using between to get all products that have 'length' between 0 and 5.

SELECT products.name,products.id

FROM products

JOIN attribute_value_product on products.id = attribute_value_product.product_id

JOIN attribute_values on attribute_value_product.attribute_value_id = attribute_values.id

JOIN attributes on attribute_values.attribute_id = attributes.id AND attributes.name = 'length'

WHERE substring_index(attribute_values.value,'inch',1) + 0 BETWEEN 0 AND 5

Everything works fine however I am getting plenty of warnings:

Warning: #1292 Truncated incorrect DOUBLE value: 'black'

Warning: #1292 Truncated incorrect DOUBLE value: 'phat farm'

Warning: #1292 Truncated incorrect DOUBLE value: '2 kg'

Warning: #1292 Truncated incorrect DOUBLE value: 'roca wear'

it looks to me like that substring is going through all attribute_values in the database, even those that are not reffering to attribute 'length' - is it possible to change that ?

mysql substring

share|improve this question

asked 10 mins ago

neocrkneocrk

1

SELECT products.name,products.id

FROM products

JOIN attribute_value_product on products.id = attribute_value_product.product_id

JOIN attribute_values on attribute_value_product.attribute_value_id = attribute_values.id

JOIN attributes on attribute_values.attribute_id = attributes.id AND attributes.name = 'length'

WHERE substring_index(attribute_values.value,'inch',1) + 0 BETWEEN 0 AND 5

share|improve this question

asked 10 mins ago

neocrkneocrk

1

share|improve this question

asked 10 mins ago

neocrkneocrk

1

asked 10 mins ago

neocrkneocrk

1

asked 10 mins ago

neocrkneocrk

1