Record ID customer number cashier time sales amount type
00023351 010006 2009-09-27 week 58.00 special price
00023372 030031 2009-09-27 21:33 69.00 special price
00023447, 040102, 2009-09-28 and 69.00 special price
00023448, 020173, 2009-09-28 and 69.00 special price
00023449, 040017, 2009-09-28 and 69.00 special price
00023464 030132 2009-09-28 21:37 normal 81.00
00023465 020145 2009-09-28 "normal 60.00
00023466 030087 2009-09-28 when 72.00 normal
00023467 020102 2009-09-28 21:46 normal 51.00
00023469 040051 2009-09-28 21:51 normal 60.00
00023472 010299 2009-09-28 22:00 60.00 normal
00023496 010128 2009-09-29 fell 72.00 special price
00023499 040239 2009-09-29 when 51.00 special price
00023500 030108 2009-09-29 when 60.00 special price
00023501 030089 2009-09-29 when 72.00 special price
00023502 030068 2009-09-29 when 81.00 special price
00023503 020013 2009-09-29 when 60.00 special price
00023504 010247 2009-09-29 when 162.00 special price
00023505 020255 2009-09-29 when 51.00 special price
00023506 020132 2009-09-29 when 60.00 special price
00023507 010229 2009-09-29 when 81.00 special price
00023518 020179 2009-09-29 20:03 specials
81.0000023521 020183 2009-09-29 unto special 81.00
00023526 010149 2009-09-29 20:58 specials
77.0000023607 010078 2009-09-30 19:46 specials
81.0000023608 020051 2009-09-30 19:46 specials
77.0000023609 010158 2009-09-30 19:46 specials
60.0000023610 040107 2009-09-30 19:46 specials
81.0000023611 010044 2009-09-30 19:46 specials
180.00
Select * from rfm2 where customer=10006, so that can find the customer=10006 results, why select * from rfm2 where type=special offer the result is empty, I want to type=special screening out, how to solve

CodePudding user response:

Special price=& gt; 'special'
Text type need single quotation marks

CodePudding user response:

reference 1st floor Runnerchin response:

special offer=& gt; 'special'
Text type need quotes

with single quotes, double quotes also tried

CodePudding user response:

Stick your build SQL table

CodePudding user response:

What is sales type fields type?

CodePudding user response:

reference yenange reply: 3/f

paste your build table SQL

drop table if the exists rfm2;
The create table rfm2
(
Id varchar (20),
The customer int (10),
The date a datetime (6),
Money NUMERIC (8),
Type varchar (20)
);

CodePudding user response:

reference 4 floor sinat_28984567 response:

sales type field type is what?

varchar (20)

CodePudding user response:

reference 5 floor moshangdanqing reply:

Quote: refer to the third floor yenange response:

Stick your build table SQL

drop table if the exists rfm2;
The create table rfm2
(
Id varchar (20),
The customer int (10),
The date a datetime (6),
Money NUMERIC (8),
Type varchar (20)
);

Basically be to see your character encoding,
You this is not produced by the mysql, you see in navicat or workbench right export structure

CodePudding user response:

refer to 6th floor moshangdanqing response:

Quote: refer to 4th floor sinat_28984567 response:

What is sales type fields type?

varchar (20)

Search out should be an error, and see what are the error

CodePudding user response:

refer to 7th floor yenange response:

Quote: refer to fifth floor moshangdanqing response:

Quote: refer to the third floor yenange response:

Stick your build table SQL

drop table if the exists rfm2;
The create table rfm2
(
Id varchar (20),
The customer int (10),
The date a datetime (6),
Money NUMERIC (8),
Type varchar (20)
);

Basically be to see your character encoding,
You this is not the mysql, you see in navicat or workbench right export structure under

- Table structure for ` rfm2 `
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
DROP TABLE IF the EXISTS ` rfm2 `;
The CREATE TABLE ` rfm2 ` (
` id ` varchar (20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
` customer ` int (10) NULL DEFAULT NULL,
` date ` datetime (6) NULL DEFAULT NULL,
` money ` decimal (8, 0) NULL DEFAULT NULL,
` type ` varchar (20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
)
ENGINE=InnoDB
The DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
; MS SQL open so long

CodePudding user response:

refer to the eighth floor sinat_28984567 response:

Quote: refer to the sixth floor moshangdanqing response:

Quote: refer to 4th floor sinat_28984567 response:

What is sales type fields type?

varchar (20)

Search out should be an error, see report are the error

is not an error, show only the empty

CodePudding user response:

Use type LIKE '% % specials' try if there are results show that the field has an identification characters before and after

CodePudding user response:

nullnullnullnullnullnullnullnullnullnullnullnullnullnull